I have to create a website and a database, but I 've only access for the server by ftp.
Is there a possibility to create and run some kind of sql script automaticly if I've only have access via ftp?!
(Using sqlserver 2000)
tia john
No, to the best of my knowledge you cannot run a SQL script solely through FTP. Surely your ISP must give you some sort of interface for creating tables?Hi there,
Can someone please help me how to generate the list of all "user" in a database and it's access role? really need it . .
Thanks
I am guessing you are looking for the information that is accessible from the following catalog views:
· Sys.database_principals http://msdn2.microsoft.com/en-us/library/ms187328.aspx
· Sys.database_role_members http://msdn2.microsoft.com/en-us/library/ms189780.aspx
· Sys.database_permissions http://msdn2.microsoft.com/en-us/library/ms188367.aspx
I would also like to recommend the following links from BOL:
· Principals http://msdn2.microsoft.com/en-us/library/ms181127.aspx
· Permissions hierarchy http://msdn2.microsoft.com/en-us/library/ms191465.aspx
· Database-level roles http://msdn2.microsoft.com/en-us/library/ms189121.aspx
Hopefully these links will help you find the answer you are looking for.
Please let us know if you have further questions.
Thanks,
-Raul Garcia
SDE/T
SQL Server Engine
|||Thanks for the quick reply, is there any possbile way I can make a select stament with an out like this (ex only)
User ServerRole DBRole Permission ?
Actully this is my first task in work . . we need this fof auditing purposes . . . Pls help
Raul Garcia - MS wrote:
I am guessing you are looking for the information that is accessible from the following catalog views:
· Sys.database_principals http://msdn2.microsoft.com/en-us/library/ms187328.aspx
· Sys.database_role_members http://msdn2.microsoft.com/en-us/library/ms189780.aspx
· Sys.database_permissions http://msdn2.microsoft.com/en-us/library/ms188367.aspx
I would also like to recommend the following links from BOL:
· Principals http://msdn2.microsoft.com/en-us/library/ms181127.aspx
· Permissions hierarchy http://msdn2.microsoft.com/en-us/library/ms191465.aspx
· Database-level roles http://msdn2.microsoft.com/en-us/library/ms189121.aspx
Hopefully these links will help you find the answer you are looking for.
Please let us know if you have further questions.
Thanks,
-Raul Garcia
SDE/T
SQL Server Engine
The code below works fine to an Access db. I know I've got to change all the Ole objects below to SQL objects to connect to SQL server. But try as I might, I'm still not getting them right. Can anyone help by showing me how to change the code? Please just take the code and substitute the SQL connection strings for the Access string. That way even I could understand it. Sigh.
www.connectionstrings.com show the connection strings for SQLClient:
Public Class FunctionsPublic Function GetCommandObject(ByVal strCommand As String, ByVal strPath As String, ByVal ExecuteIt As Boolean) As Data.OleDb.OleDbCommand
Dim objConnection As Data.OleDb.OleDbConnection = GetConnectionObject(strPath)
objConnection.Open()
Dim objCommand As New Data.OleDb.OleDbCommand(strCommand, objConnection)
If ExecuteIt = False Then
Return objCommand
Else
objCommand.ExecuteNonQuery()
End If
objConnection.Close()
End FunctionPublic Function GetConnectionObject(ByVal strPath As String) As Data.OleDb.OleDbConnection
Dim objConnection As New Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strPath)
Return objConnection
objConnection.Close()
End FunctionPublic Function GetReaderObject(ByVal strCommand As String, ByVal strPath As String) As Data.OleDb.OleDbDataReader
Dim objCommand As Data.OleDb.OleDbCommand = GetCommandObject(strCommand, strPath, False)
Dim objReader As Data.OleDb.OleDbDataReader = objCommand.ExecuteReader(CommandBehavior.CloseConnection)
Return objReader
objReader.Close()
End FunctionEnd Class
Standard Security:
"Data Source=Aron1;Initial Catalog=pubs;User Id=sa;Password=asdasd;"
- or -
"Server=Aron1;Database=pubs;User ID=sa;Password=asdasd;Trusted_Connection=False"
(booth connection strings produces the same result)
Trusted Connection:
"Data Source=Aron1;Initial Catalog=pubs;Integrated Security=SSPI;"
- or -
"Server=Aron1;Database=pubs;Trusted_Connection=True;"
(booth connection strings produces the same result)
(use serverName\instanceName as Data Source to use an specifik SQLServer instance, only SQLServer2000)
Connect via an IP address:
"Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=pubs;User ID=sa;Password=asdasd;"
(DBMSSOCN=TCP/IP instead of Named Pipes, at the end of the Data Source is the port to use (1433 is the default))
Declare the SqlConnection:
C#:
using System.Data.SqlClient;
SqlConnection oSQLConn = new SqlConnection();
oSQLConn.ConnectionString="my connectionstring";
oSQLConn.Open();
VB.NET:
Imports System.Data.SqlClient
Dim oSQLConn As SqlConnection = New SqlConnection()
oSQLConn.ConnectionString="my connectionstring"
oSQLConn.Open()
Which one you use depends upon how you want to login. You can use a username and password, or you can use a Trusted Connection, in which case, the ASPNET user on the Web Server must be a user in SQL Server (this is awkward if you are running SQL Server on a machine other than the Web Server.
