Viewing 15 posts - 961 through 975 (of 1,065 total)
This may be a permissions issue.
Make sure that the SQL Server startup account has "Full Control" permission to the drives you want to backup to.
June 4, 2003 at 6:52 am
SQL Server is doing integer division, as it has correctly guessed that 1000 and 34 are integers.
If you force one of the values to be decimal, SQL Server will...
June 4, 2003 at 3:39 am
This may not be particularly efficient, especially if the table is large, but try this:-
select (select count(*) from names n2 where n2.name <= n1.name) as SeqNo,name from names n1 order...
June 3, 2003 at 4:42 am
If you have any monitoring software (e.g. BMC Patrol) that hooks into the performance counters, then they have to be shut down as well before restarting SQL Server.
June 3, 2003 at 2:33 am
This could be due to a known issue with SP3.
If Perfmon is active on the machine running SQL Server at the time the SQL Service is started, you lose the...
June 2, 2003 at 8:44 am
It's probably easier to use an Alias, rather than the real server name.
If you set up a server alias (using the Client Network Utility) called X, you can write your...
June 2, 2003 at 8:36 am
If SQL Server is set to 'Dynamically' manage the memory, then the fact that it is using 90% of the memory shouldn't be a problem, as SQL Server will release...
May 22, 2003 at 9:50 am
Unfortunately, in some locales Franks solution will give an error when you reach the 13th of the month, as SQL Server may interpret the date as dd.mm.yyyy or mm.dd.yyyy, depending...
May 21, 2003 at 6:36 am
SQL Server has to decide what the data type of your [Production Ratio] column should be.
To do this, it looks at all the possible data types in your case...
May 21, 2003 at 3:08 am
Shah_a
None of our servers have named pipes enabled, and we have no problem with failover.
May 15, 2003 at 1:18 am
The error was after a SQL2K upgrade to SP3.
May 14, 2003 at 1:39 am
Had a similar problem recently after an SP3 upgrade (SKL2K Active/Active cluster).
With Named Pipes installed, the automatic TCP/IP port detection stopped working, and the only way to connect using TCP/IP...
May 13, 2003 at 3:10 am
I have noticed that SQL Profiler filters seem to be case sensitive. Check to see if your filter exactly matches the EXEC being submitted by your dev guy.
May 12, 2003 at 1:26 am
You need to increase the size of your 'tempdb' database.
Either increase the size manually via Enterprise Manager, or check the box to allow Auto Grow.
May 12, 2003 at 1:20 am
You forgot the 'END' to go with the 'ELSE BEGIN' line
May 8, 2003 at 3:30 am
Viewing 15 posts - 961 through 975 (of 1,065 total)