Viewing 15 posts - 28,501 through 28,515 (of 39,771 total)
Red Gate's Log Rescue is SS2K only. ApexSQL and Lumigent have 2005 tools.
Could it be reindexing? Those are moved across and could cause the logs to grow.
May 19, 2008 at 8:51 am
I bet that once a named instance exists, the setup program detects it and prevents the install. It's possible that a scripted install might work, but I've not tried it.
May 19, 2008 at 8:49 am
The user owns an object, in this case, a schema.
Move the schema to a new user and then drop this one.
May 19, 2008 at 8:48 am
I've debated this a bit and there doesn't seem to be a reason to do this. It's likely poor evaluation of the indexes in place and just adding another one.
My...
May 19, 2008 at 8:47 am
First I think you need
... sp_executeSQL N' alter table ...'
And it works for me, SS2K5, dev, SP2.
Columns added to table.
Do you have permissions to add columns?
May 19, 2008 at 8:46 am
Steve has stated the question well and I don't think this is supported. I think the intention is that you'll only stay the same or upgrade versions, not downgrade to...
May 19, 2008 at 8:42 am
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
Viewing 15 posts - 28,501 through 28,515 (of 39,771 total)