Viewing 15 posts - 3,181 through 3,195 (of 3,232 total)
Are you sure this is not an intrusion attempt? I am assuming that by 'Application Event Log', you mean the Windows Application event log and not a log that is...
November 16, 2005 at 3:38 pm
You will have to use the variable name to create a dynamic SQL string and use sp_executesql.
declare @DBname varchar(20),
@sqlstring nvarchar (4000)
set @dbname = 'testme2'
set @sqlstring = N'create database '...
November 16, 2005 at 3:33 pm
Gloria Mark is a genius....reading her article was an interuption and it took me about 25 minutes to get back to work!!
November 16, 2005 at 8:51 am
In the case where your routine will return the defaut instance resource name, I don't know as I don't know what method your routine is using to determine the resource...
November 14, 2005 at 3:54 pm
Is your slow response something new? Is it only slow on this one specific server? From a memory perspecitve, it does not look like you have AWE enabled. With that...
November 14, 2005 at 3:37 pm
What is the data type on the columns where your time is expressed with 10 numbers?
November 14, 2005 at 3:17 pm
Sorry I could not be of more help....
November 14, 2005 at 2:30 pm
Play around with the GETUTCDATE() function:
DECLARE @LocalDate DATETIME
SET @LocalDate = GETDATE()
-- convert local date to utc date
DECLARE @UTCDate DATETIME
SET @UTCDate = DATEADD(Hour, DATEDIFF(Hour, GETUTCDATE(), GETDATE()), @LocalDate)
-- convert utc date to...
November 14, 2005 at 2:24 pm
I would suggest possibly using the job setup output file option to possibly catch more information as to why your .bats are periodically failing. You may also want to write...
November 14, 2005 at 2:10 pm
Oops, here's the presentation:
November 14, 2005 at 2:03 pm
Colin,
In your first post in this thread, you mentioned that you've seen Technet presentations. I don't know if you've seen this one, so I'll post it anyway. It talks about...
November 14, 2005 at 2:00 pm
These forums are designed to provide a certain level of free help. You may want to post your query and see what kind of responses you get. Other hardware/storage/SQL...
November 14, 2005 at 1:25 pm
I hope you have a good backup/recovery strategy as this will be your most likey approach. Here is a quote from MSDN:
TORN_PAGE_DETECTION
This recovery option allows SQL Server to detect incomplete...
November 14, 2005 at 1:04 pm
I would start by running resetting the suspect flag using: sp_resetstatus [ @DBName = ] 'database'. Then run DBCC CHECKDB on all of your databases to see how big the...
November 14, 2005 at 12:54 pm
Viewing 15 posts - 3,181 through 3,195 (of 3,232 total)