Viewing 15 posts - 7,906 through 7,920 (of 14,953 total)
Alter Database requires exclusive database access. To make this work, you'd have to make the code disconnect all other connections to the database and kill all pending transactions. ...
November 4, 2009 at 8:31 am
The view is simply a pre-built select statement. When you query a view, it simply gets added to the definition of the outer query.
That means, no, it doesn't pull...
November 4, 2009 at 8:21 am
I posted a reply to that one in that thread (to keep it all in one place).
November 4, 2009 at 7:56 am
I'm not sure I'm clear on what exactly you're trying to accomplish with this.
If the first update statement updates 1 or more rows, but the second one doesn't update anything,...
November 4, 2009 at 7:55 am
It means something other than the ASCII standard tab character or spaces was used. That's why I asked about what editor you're using.
November 4, 2009 at 7:48 am
PiMané (10/31/2009)
Thanks...
So, if there's no need to point in time restore, the best for us is to have single mode, with full backups and diff backups...
November 4, 2009 at 7:43 am
I can't really recommend any classes to take, since I'm completely self-taught on the subject.
I can recommend getting a copy of the SQL Server Bible (you can find it on...
November 3, 2009 at 3:25 pm
@@Rowcount only works on the last command within the scope of the code. Thus, unless the trigger itself is updating something, it will return 0. What you need...
November 3, 2009 at 3:18 pm
Delete the indents.
Are you using an editor other than Management Studio for this?
November 3, 2009 at 3:15 pm
If you select from the backup tables in msdb, you should be able to get the file name of the most recent full backup that's more than 1 day old...
November 3, 2009 at 3:02 pm
Haven't tried it, but I imagine Express would work just fine for that. Just keep the databases small and no heavy transactions.
November 3, 2009 at 2:57 pm
I had to delete your indents and fix a typo in the Close command, but after that it compiled and ran on my machine.
There weren't any SPIDs to close, since...
November 3, 2009 at 2:55 pm
Don't do it in a trigger. Set up a job that archives data on a scheduled basis. That almost always works better.
November 3, 2009 at 2:48 pm
Viewing 15 posts - 7,906 through 7,920 (of 14,953 total)