Viewing 15 posts - 2,581 through 2,595 (of 3,011 total)
We are running a number of SQL Server instances on VMWare with no problems. Most are dev/test/QA systems, but we do have some production systems also, and we are...
January 10, 2008 at 10:27 am
You could at try to roll forward all the way to the end of the last log file, and then run DBCC CHECKDB to see if if there is any...
January 9, 2008 at 1:11 pm
You can get this information with the PSINFO utility available on the link below.
http://technet.microsoft.com/en-us/sysinternals/bb896649.aspx
Sample command and output:
psinfo \\MyServerName -D disk
PsInfo v1.73 - Local and remote system information viewer
Copyright (C) 2001-2005...
January 9, 2008 at 9:21 am
Create a stored procedure to do backups on the SQL Express server, and then execute it with SQLCMD or OSQL in a job from another server. You will have...
January 9, 2008 at 9:07 am
You cannot do that in a default, because column values are not available in a default.
Just do the conversion when you insert the data. Or don't bother creating a...
January 9, 2008 at 8:54 am
I made extensive use of stored procedures that created temporary stored procedures for reporting in a data mart application. This reason I did this was because there could be...
January 8, 2008 at 3:31 pm
holly_westell (1/7/2008)
January 8, 2008 at 2:37 pm
...Michael, they already think im a SOB! haha! Actually they all think I'm overreacting. Even some of the people at my own company who have to do work...
January 8, 2008 at 1:22 pm
I don't really know, but I think there may be a performance reason to do this with some versions of Oracle.
I don't think there is any good reason to do...
January 8, 2008 at 11:56 am
You should really contact an accountant about this.
If you don't set it up right, tax penalties can be quite severe.
January 8, 2008 at 11:53 am
If he has access to create the tables in tempdb, setup a job that runs ever hour or so to delete them.
When his stuff starts failing, tell him you have...
January 8, 2008 at 11:48 am
Greg Snidow (1/8/2008)
John Mitchell (1/8/2008)
Could it be to do with your regional settings? What happens if you do SELECT CAST (GETDATE() AS datetime)?John
If I do that I get seconds...
January 8, 2008 at 10:01 am
My mistake, I didn't realize the OBJECT_ID function OBJECT_TYPE parameter was available in earlier versions of SQL Server.
I checked, and it was also available in SQL 7.0. ...
January 8, 2008 at 9:45 am
Sergiy (1/7/2008)
Michael Valentine Jones (1/7/2008)
Your checks are not valid for SQL 7.0 and 2000. (This is the SQL Server 7,2000 T-SQL forum)
It's because undocumented parameter Jeff used.
Follow BOL prescriptions...
January 7, 2008 at 5:26 pm
Jeff Moden (1/4/2008)
1. Check if temp table exists...
IF OBJECT_ID('TempDB..#temptablename','U') IS NOT NULL
PRINT 'Table Exists'
...
January 7, 2008 at 3:57 pm
Viewing 15 posts - 2,581 through 2,595 (of 3,011 total)