Viewing 15 posts - 331 through 345 (of 617 total)
There may be a more elegant way to handle this, but unless you are talking massive amounts of data (and then I'm not sure about performance) I like subqueries instead...
February 23, 2011 at 3:25 pm
Have you tried the import wizard? There are several methods to get to it, but the one I use is to right click on the database name, tasks ->...
February 23, 2011 at 8:35 am
The reason notepad keeps running is that it hasn't been told to close. You've opened it in a shell that can't get any further responses from you so it...
February 23, 2011 at 8:29 am
tilew-948340 (2/12/2011)
Now, sqlcmd explains everything
Thanks for...
February 13, 2011 at 11:52 pm
Good question. I particularly like using :connect when I need to test something on multiple servers and don't feel like changing my connection 10+ times.
February 11, 2011 at 10:57 am
Good question. I appreciate the update of information. I use sp_change_users_login fairly frequently. I'll miss the report option though.
February 11, 2011 at 10:50 am
I did in fact just find a solution. It turns out the AcquireConnection method of a SMO connection is an SMO Server, so I was able to use the...
February 7, 2011 at 1:05 pm
Is there no way to generate the connection using the AcquireConnection method and pass it to the SMO server object? That way I don't have to mess with the...
February 7, 2011 at 10:02 am
Any chance you know how to pull SQL Auth from a connection manager and use it with the server object?
Thanks
Kenneth
February 7, 2011 at 9:23 am
Unfortunatly I'm having to use a sysadmin login and I don't want to hard code my password into the code. Is there a way to pull it from the...
February 7, 2011 at 9:23 am
Great article. I'm actually working on something similar and I'm hoping you can help me out with one last small piece. I'm trying to pull the connection information...
February 7, 2011 at 9:02 am
Thanks for the attempt. I'll be patching and rebooting the dev server this weekend so we will see if that helps. I had a SPN removed from the...
January 10, 2011 at 3:11 pm
On the involved servers, check that you are connected using Kerberos by selecting from sys.dm_exec_connections where session_id=@@SPID. Also check for any error messages in the error log.
All of them show...
January 10, 2011 at 1:36 pm
We are trying to move away from SQL Authentication for security and maintenance issues. Specifically with 1000+ employees the 5 SQL DBAs don't want to have to manage creating...
January 5, 2011 at 3:31 pm
This is probably a stupid question but are you going to the status tab and checking that it is enabled and the locked out check box is unchecked?
Kenneth
January 5, 2011 at 1:39 pm
Viewing 15 posts - 331 through 345 (of 617 total)