Viewing 15 posts - 43,291 through 43,305 (of 49,571 total)
Terri (11/7/2008)
Wouldn't using views or stored procedures solve the problem of the jr HR person. In our shop we never give access to base tables. Either we a...
November 8, 2008 at 4:27 am
ramadesai108 (11/7/2008)
means t.SoldYR2 has to be at least greater than zero). If it is greater than zero, then it cannot be...
November 8, 2008 at 3:34 am
noeld (11/6/2008)
BACKUP LOG [AdventureWorks] WITH NO_LOG
FYI: This operation is deprecated
So is Backup log with truncate only and both have been completely removed in SQL 2008.
November 8, 2008 at 3:25 am
rosh (11/6/2008)
Would null values cause this.See if ISNULL helps.
Null won't cause a divide by zero. Anything divided by null (or added to null or multiplied by null, ...) is null....
November 8, 2008 at 3:24 am
Karl Klingler (11/7/2008)
just so i know - do you guys think it possible that an open transaction getting rolled back on the table might be a reason for this kind...
November 8, 2008 at 3:23 am
Build 1399 is RTM, meaning it's never been patched at all. The latest will be SP2 CU 10. Get SP2 and apply it to the machine where the client tools...
November 8, 2008 at 3:20 am
Depends. Was record a deleted before Diff2 was taken, or afterwards?
November 8, 2008 at 3:15 am
Logins can be created on the mirror, because logins go into the master database. Make sure that you script the login from the principal with the SID. That will ensure...
November 6, 2008 at 3:01 pm
Does the path F:\MSSQL.1\MSSQL\LOG\ exist?
If so, what files are in there?
Are there any other errror relating to tempDB or Model in the error log?
November 6, 2008 at 2:57 pm
Can you ask the users what exactly they mean by 'locking'?
dbcc traceon(1204, 1222, 3605, -1)
3605 isn't required for deadlock graphs. Personally I find 1204 to be unnecessary if 1222 is...
November 6, 2008 at 2:06 pm
Did you do anything to the tempdb files? Did you copy then anywhere, rename anything or anything like that. Basically, what did you do to the server between the time...
November 6, 2008 at 2:03 pm
You're dividing by t.SoldYR1 in the code that works and t.SoldYR2 in the code that doesn't. Are there any rows where t.SoldYR2 is 0?
November 6, 2008 at 2:01 pm
These two should give you a good place to start. You may have to tweak an existing script if you can't find one that does exactly what you want.
http://www.sqlservercentral.com/scripts/Index+Management/63649/
http://www.sqlservercentral.com/scripts/SQL+Server+2005/61278/
November 6, 2008 at 1:54 pm
clive (11/6/2008)
If you truncate a log file which is usually around 2GB, but is now 7GB due to bulk inserts, truncating it is recommended (unless you have plenty disk space...
November 6, 2008 at 1:50 pm
TRACEY (11/6/2008)
November 6, 2008 at 1:44 pm
Viewing 15 posts - 43,291 through 43,305 (of 49,571 total)