SQL Server 2008 Administration

• Topics

  Started by

  Posts

  Last post

• MY SSIS 2008 R2 PACKAGE FILED DUE TO FOLLOWING ERROR

  ENVIRONMENT :SQL 2008 R2 (STANDARD EDTION 64 BIT) ERROR DESC =========== Executed as user: XXX\SYST…

  pradeep.k 50453

  2 replies

  11 years, 10 months ago

  By: pradeep.k 50453

• created Subscription not lsited under local Subscription menu

  Hello , Here i am trying to setup a Transactional Replication in my local environment . prop…

  vivekkannan.k

  1 replies

  11 years, 10 months ago

  By: Keith Tate

• Mirroring database can take Tlog backup?

  Hi, Database has been configured in Mirroring for high availabilty, Can we take Tlog backup on re…

  SQL Galaxy

  3 replies

  11 years, 10 months ago

  By: Gail Shaw

• Sql server logs

  Hi every one, I want to remove or clear log file viewer from sql server logs in sql server 2012 kin…

  rajnidas.y

  4 replies

  11 years, 10 months ago

  By: rajnidas.y

• How to rollback a service pack in sql 2005 and sql 2008 ?

  Hi All, Can anyone share information about rollbacking a service pack? What are pre-cautionary step…

  Oracle_91

  6 replies

  11 years, 10 months ago

  By: walkercp

• Query to find blocking is getting blocked.

  I have this query to find blocking: SELECT DISTINCT sp.spid SPID, sp.blocked BlockingSPID, DB_NAME…

  SQLHeap

  3 replies

  11 years, 10 months ago

  By: Grant Fritchey

• CPU always utilize 60% constantly?

  Hi, CPU always utilize 60 % constantly, attached here execution plan. I checked execution plan hand…

  SQL Galaxy

  5 replies

  11 years, 10 months ago

  By: Grant Fritchey

• CheckPoint

  I have a SPID 18 doing checkpoing for a user database since last server reboot. There is no related…

  Grace09

  8 replies

  11 years, 10 months ago

  By: Gail Shaw

• Sleeping processes

  I have a sql cluster and it has about 500 sleeping spid, what should I do? Thank in advance.

  Grace09

  4 replies

  11 years, 10 months ago

  By: Grace09

• CLR assembly DLL file location? Corrupted

  CLR file location. Is it C:\windows\Framework\version? Frequently facing problems SSIS - backup pa…

  SQL Galaxy

  5 replies

  11 years, 10 months ago

  By: durai nagarajan

• Failed install - 2008 Standard

  Hey, As title. Failed during an install of only Client Tools Connectivity and Management Studio Com…

  lanky_doodle

  2 replies

  11 years, 10 months ago

  By: lanky_doodle

• Exception of type 'System.OutOfMemoryException' was thrown. ( I am need to see if there are DUPLICATE ROWS in table).

  How else can I do it? How can I overcome this error? I am trying to see if there are any duplicate…

  VoldemarG

  2 replies

  11 years, 10 months ago

  By: Igor Micev

• 2008 SP3 upgrade.

  I have to upgrade SP3 for sql 2008 64bit stand alone server. Does the windows server need a reboot?…

  SQLisAwe5oMe

  2 replies

  11 years, 10 months ago

  By: digitalox

• Mirroring, Replication or SSIS package

  Im wanting to build a staging server for the ETL work to be carried out on my databases before extr…

  ps_vbdev

  1 replies

  11 years, 10 months ago

  By: Evil Kraig F

• SQL Agent job duration in real time

  Is there a way to get the real time execution period from SQL Agent in a table somewhere? sysjobhis…

  DVSQL

  1 replies

  11 years, 10 months ago

  By: DVSQL