Viewing 15 posts - 28,546 through 28,560 (of 39,810 total)
Is this in the log for the maintenance plan? Which job is this for?
May 19, 2008 at 8:39 am
As mentioned above, someone must be changing things. SQL server doesn't alter permissions for any reason.
May 19, 2008 at 8:38 am
SQL Server will tend to take as much memory as it can unless you limit it. This memory was probably used at some point and SQL Server isn't going to...
May 19, 2008 at 8:37 am
The values inserted aren't the same. You're using a code that's different fo the first "s" in the #temp table, so it's not equal to 'Malteser Schlossschule'. the cast to...
May 19, 2008 at 8:35 am
Micheal typed the words before I could. I'd go with the names, for the same reasons. They shouldn't change, and if they do, this helps you follow the history in...
May 19, 2008 at 7:01 am
SSIS or DTS can do this.
It's basically script the objects, run the script (you might have errors), and then copy the data.
Since the way things are structured is different, you...
May 19, 2008 at 6:55 am
You would be better off posting this on a web site devoted to development.
The idea of the browser is that it isn't connected to the back end. each page, even...
May 19, 2008 at 6:53 am
It is a good basic T-SQL book, but it doesn't cover 2005 stuff very well, which is disappointing with the sticker on the front that says it does.
I'm working my...
May 18, 2008 at 12:38 pm
Jeff and his RBAR 😉
Learn how recursion works. Even if you don't use it in SQL Server, it's a good tool to understand.
May 17, 2008 at 7:54 pm
You need to shut SQL Server down for this to be safe and effective. I know people don't and vendors say it will work, but I'm not sure I trust...
May 16, 2008 at 9:34 am
AFAIK in this case it would be the same plan. An IN is a shortcut for multiple ORs.
May 16, 2008 at 9:33 am
What doesn't change? are you sure the record didn't have a null?
Run the query without the stored procedure, just the update. Does it work?
May 16, 2008 at 9:32 am
The scenarios I saw weren't overly complex, but they cover a wide variety of add/edit/delete objects (add user, edit linked server, etc.), so the best thing is to be sure...
May 16, 2008 at 9:31 am
The inplace upgrade is a one-way thing. There's no easy rollback. You can uninstall, reinstall 2000, attach dbs, etc., but it's slow. If you have time, and people understand this...
May 16, 2008 at 9:30 am
Viewing 15 posts - 28,546 through 28,560 (of 39,810 total)