I need to create a login in a stored procedure.
CREATE LOGIN [MYDOMAIN\TestPerson] FROM WINDOWS;
Above works fine. However, I need to pass the login name into the spoc. The code below does not ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2297...
I have an application that requires db_owner of certain databases in SQL. I select my user mappings and all is well. After I reboot my server all those settings are missing. This is a new server ru...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2311...
I am trying to deploy my ssis package to my sql 2005 sp2 instance. I followed the MS tutorial and everything in the deployment process seems to go as expected. When I create a new job and point i...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2314...
I am setting up a development SQL box. I have already copied over all of the DB's and now I am looking for a way to move over all of the login information. Any ideas?
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23156488.html
I am using a software called GFI mail archiver.Tried to create a store.
It requires to establish connection to DB server for checking schema. Database server is called DB1.Windows authentication w...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23252203.html
While trying to start up SQL 2005 on a cluster, we receive the error that the IP dependency could not be found. We verified that the dependencies are correct based upon the other clusters we have ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2327...
Having had a failed upgrade last week, I had to restore a database, which got stuck running the script. I then cancelled it and reattempted, which also got stuck. However, when I cancelled it aga...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2328...
HI
I have a SQL 2005 SP2 server and currently have four databases installed. All of theses currently have healthy size and seem to be fine. I have notice that the log files are all set to restr...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2329...
I just finished setting up a new SQL 2005 SP2 server and am seeing the following error quite frequently in the event logs. It doesn't appear to affect the operation of the server in any way, but wo...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2337...
I have limited space on the C drive and would like to install the SP2 patch for SQL 2005.
What is the minimum physical memory required for this installation? Thanks,
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2339...
