Viewing 15 posts - 3,331 through 3,345 (of 7,429 total)
Hem, seems I was wrong. Thanks for pointing that out. I will see what I can find out.
February 19, 2003 at 11:10 am
You cannot use the Upgrade Wizard to move a 6.5 server to 2000, you have to go to 7 then 2000.
Otherwise you have to use the DTS Import/Export wizard but...
February 19, 2003 at 8:32 am
Yes you must restart the SQL Server service.
I do believe they are in SQL Server Logs but don't have my documentation here for reference.
February 19, 2003 at 8:18 am
Unfortunately as you cannot parameterize the name of an object such as a function for it to use. Thus you need dynamic SQL. However if you have a small number...
February 19, 2003 at 4:59 am
WHat account is SQLAgent running under. If the account is an Admin and not given access to it's user account then you have denied it.
February 19, 2003 at 4:56 am
Sorry, I am not sure where you mean, sounds like machine regional settings is what you are saying. What I amm saying is the SL User account has a language...
February 19, 2003 at 4:45 am
I just tried myself on SQL 7 SP2, 3 and 4 and none stop. But on SQL 2000 works as should. I checked and found no report of this but...
February 19, 2003 at 4:35 am
quote:
but the data paging issue won't be corrected.
What do you mean here?
Also, so I...
February 19, 2003 at 3:38 am
Run DBCC CHECKTABLE against that table or DBCC CHECKDB against MSDB and see if it reports any errors.
February 19, 2003 at 3:32 am
Good site with lots of tips around monitoring (other than this one). http://www.sql-server-performance.com
February 18, 2003 at 6:00 pm
Unless you use the TRUNCATEONLY option...
Def
quote:
Causes any unused space in the files to be released to the operating system and shrinks the...
February 18, 2003 at 5:59 pm
The first is safer and generally better.
The second can give bad results and cause unexpected behavior. The problem as is is the majkey exists as a column name in both...
February 18, 2003 at 5:43 pm
You need to be carefull and make sure you qualify the full name of a column inside a Subquery when the name exists in the outer query.
Like so
select tempTable.ID from...
February 18, 2003 at 1:39 pm
Run SQL Enterprise Manager from the Microsoft SQL Server 6.5 group
Select the server that is going to be managed and, from the Server menu, select SQL Server->Configure.
Then on the...
February 18, 2003 at 1:32 pm
To the best of my knowledge not if you want it to be required or generated by the NEWID() function as default. But there is nothing to prevent you from...
February 18, 2003 at 1:27 pm
Viewing 15 posts - 3,331 through 3,345 (of 7,429 total)