Viewing 15 posts - 16,516 through 16,530 (of 26,487 total)
Okay, took awhile but I finally have it written using ALTER USER.
declare @ DatabaseName sysname = 'H90TST'; -- Added a space between @ and variable name to post code
declare...
March 16, 2010 at 9:38 am
Paul White (3/16/2010)
sp_change_users_login is on the deprecation list - it will be removed from a future version of SQL Server.You should use ALTER USER...WITH LOGIN instead.
Good point. This is...
March 16, 2010 at 6:49 am
Excellent article, Bob. It should be required reading for newbies so that the understand why we tell them "It Depends" so often.
March 16, 2010 at 6:45 am
Paul White (3/16/2010)
Isn't Bob's/Dixie's article an excellent read today?Shame about some of the layout, but hopefully that will be fixed soon.
Most enjoyable.
Not going to comment on the layout of the...
March 16, 2010 at 6:44 am
mbricker-600840 (3/16/2010)
I used to work for a company that had a frozen marguerita machine in the kitchen.
Every afternoon, we would fire it up so it...
March 16, 2010 at 6:41 am
[font="Comic Sans MS"]Party at the Tent in the Desert. The Hippo has been alerted that guests will be arriving.[/font]
This post is number 10,001
March 16, 2010 at 5:42 am
I use the following code to fix orphaned SQL Server logins in my production HR and Finance systems. See if it will help you with your problem. You...
March 16, 2010 at 5:37 am
[font="Comic Sans MS"]Party Time is just around the corner! Just one more post is needed![/font]
March 15, 2010 at 12:55 pm
Les Cardwell (3/15/2010)
Also, this:
DECLARE @selectDate = getdate()-365
won't work. In SQL Server 2008 it needs to be like this:
DECLARE @selectDate datetime = getdate()-365
For what it's worth, it doesn't work in...
March 15, 2010 at 12:52 pm
Timewarp? Redo the weekend? I don't think so. The Air Force Academy Fighting Falcons Hockey Team worked hard to beat the Black Knights of Army! They...
March 15, 2010 at 12:27 pm
SQL Server 2008
declare @MyDate1 datetime,
@MyDate2 datetime2;
set @MyDate1 = getdate();
set @MyDate2 = @MyDate1;
select @MyDate1 - 10; -- Works
select @MyDate2 -...
March 15, 2010 at 12:10 pm
Alvin Ramard (3/15/2010)
Lynn Pettis (3/15/2010)
Alvin Ramard (3/15/2010)
CirquedeSQLeil (3/15/2010)
Lynn Pettis (3/15/2010)
Alvin Ramard (3/15/2010)
Anybody else see a problem with this statement?DECLARE @selectDate = getdate()-365
Yes, in SQL Server 2008 it is missing the...
March 15, 2010 at 11:59 am
CirquedeSQLeil (3/15/2010)
Lynn Pettis (3/15/2010)
Les Cardwell (3/15/2010)
March 15, 2010 at 11:58 am
Alvin Ramard (3/15/2010)
CirquedeSQLeil (3/15/2010)
Lynn Pettis (3/15/2010)
Alvin Ramard (3/15/2010)
Anybody else see a problem with this statement?DECLARE @selectDate = getdate()-365
Yes, in SQL Server 2008 it is missing the data type. Should...
March 15, 2010 at 11:51 am
Viewing 15 posts - 16,516 through 16,530 (of 26,487 total)