Viewing 15 posts - 76 through 90 (of 188 total)
Jason.. thanks for replying.
the query you provided:
SELECT TOP 2
START_DT, END_DT
FROM
ods32.dbo.ts_pd_sch
WHERE
END_DT <= GETDATE()
ORDER BY
END_DT...
March 24, 2008 at 9:12 am
I tried doing that. the problem is catalog was initially build on a drive that doesnt exist on this machine. and when I click properties i get the error message...
March 17, 2008 at 9:08 am
ahh... so operator can I use to get the difference between two tables. In oracle there is 'MINUS' operator. what is SQL Server equivalent to that?
Thanks
February 21, 2008 at 5:14 am
well log_shipping_secondary_databases table in the monitoring sql instance is empty. however when I generate a transaction log status report from primary instance it shows me databases being log shipping but most...
September 19, 2007 at 8:25 am
I used following and it worked:
DECLARE
@RenameTableDetail varchar(50)
SELECT
@RenameTableDetail = Replace
June 12, 2007 at 8:41 am
Were you able to find any answer on this topic?
May 8, 2007 at 9:47 am
whenever a block occurs during the day and its over 10 minutes. can you create a daemon or agent that can run constantly to look for these activities?
April 26, 2007 at 8:34 am
you can setup a job to free up space by shrinking or truncating the trans log.
April 18, 2007 at 2:13 pm
I am using mdb. Idea is to move the data to SQL Server and keep the forms and reports in access.
April 10, 2007 at 7:33 am
yes its on SAN. howcome all of a sudden permissions are corrupted.
April 4, 2007 at 3:15 pm
yes it will be put on the same disk as existing databases. isnt there a way to calculate I/O of the old server? or measure the load. that way at...
February 21, 2007 at 7:26 am
oops.. I am sorry I meant to type stats for sqlservr.exe . here is what I want to find out? Will moving this db from box xyz to clustered sql...
February 20, 2007 at 9:26 am
Viewing 15 posts - 76 through 90 (of 188 total)