Forum Replies Created

Viewing 15 posts - 556 through 570 (of 860 total)

  • RE: How to list all the objects of another server

    reggae_blur (11/9/2010)

    Parthi,

    Running the query below in Server A gives me an "Invalid Object Name" error...:-)

    SELECT * FROM ServerB.sysobjects

    Did you read my prrvious replay

    FQN-- select * from [LSname].[dbname].[schema].[object]

    November 9, 2010 at 7:06 am

    #1248258

  • RE: Update Stats job

    I stop the job by going into jobs, right clicking it, stop job..

    Stoping the job is not run next time.

    I update stats once in a week or once in 2...

    November 9, 2010 at 7:00 am

    #1248253

  • RE: Update Stats job

    rajanishvibha 3763 (11/9/2010)

    Hi

    my Name Is VIBHAVESH

    I wants to know Backup Policy

    I Have 2 TB database(SQL SERVER DB) could you help me what will be best backup policy (how to...

    November 9, 2010 at 6:48 am

    #1248241

  • RE: How to list all the objects of another server

    reggae_blur (11/9/2010)

    Hi parthi,

    Upon checking, we already have a linked server for Server B, that's why I can query successfully from Server B. My apologies.

    So, my question now is, how can...

    November 9, 2010 at 6:37 am

    #1248226

  • RE: Update Stats job

    SKYBVI (11/9/2010)

    @ mutthu

    There is no blocking

    In morning i stop the job, so whats use of killing spid ?

    I run this through a maintenance plan-->

    update statistics task--> tables and views--> update(all...

    November 9, 2010 at 6:34 am

    #1248220

  • RE: Suspect Database

    parthi-1705 (11/9/2010)

    vgtestingg (11/9/2010)

    Hi Everyone,

    I am working in SQL Server 2008. My database is displaying "Suspect" in front of database name. Can anyone suggest me, How can I...

    November 9, 2010 at 6:21 am

    #1248205

  • RE: Update Stats job

    SKYBVI (11/9/2010)

    Hi,

    I run a update statistics job in hte weekend on one of our databases, the size of the database is 100GB. It starts at 1...

    November 9, 2010 at 6:18 am

    #1248199

  • RE: How to list all the objects of another server

    reggae_blur (11/9/2010)

    Hi all.

    Is it possible to list all the objects of another server by calling it in a separate server? In my case, I have 2 servers (say Server A...

    November 9, 2010 at 5:58 am

    #1248181

  • RE: Database drops

    GilaMonster (11/9/2010)

    muthukkumaran (11/9/2010)

    Another one method -->Check the Schema change histroy.

    That report queries the default trace

    Gail,Thanks for the info.

    November 9, 2010 at 4:43 am

    #1248147

  • RE: Transaction log backup size exceeds full backup size

    Sumanta Roy (11/9/2010)

    Hi,

    In one of our production server backup of transaction log file exceeds the backup of full backup size. The backups are taken in the below order

    Full backup- Every...

    November 9, 2010 at 4:02 am

    #1248130

  • RE: Transaction log backup size exceeds full backup size

    Sumanta Roy (11/9/2010)

    What jobs run between that 12:30 log backup and the previous log backup?

    Only full backup runs at 12.00 AM between this time.

    Sumanta

    Without any modification the...

    November 9, 2010 at 3:59 am

    #1248129

  • RE: Database drops

    imSQrLy (11/8/2010)

    I recently had a client where someone dropped 2 databases thinking they were on the test sql server. I was able to see a connection to the production sql...

    November 9, 2010 at 3:50 am

    #1248126

  • RE: Problem with dbcc shrinkfile(datafile,targetsize)

    DBAsql-1046554 (11/9/2010)

    I think i can wait until the current transaction completes.

    Thank you all for your response.

    Did you killed the transaction .

    What is the status its shows?

    November 9, 2010 at 3:35 am

    #1248122

  • RE: Problem with dbcc shrinkfile(datafile,targetsize)

    steveb. (11/9/2010)

    have a read of

    http://support.microsoft.com/kb/307487#6

    to shrink the tempDb without restarting the server you need to have no activity occuring on it.

    Did you read the article...

    November 9, 2010 at 3:30 am

    #1248117

  • RE: Rebuild Index - Loghshipping

    sqldba_icon (11/8/2010)

    thanks for replies. I am talking about statistics of the database, as far as i know statistics of each database are stored in local master database. I could be...

    November 9, 2010 at 12:02 am

    #1248033

Viewing 15 posts - 556 through 570 (of 860 total)