You obviously running SQL Server on a cluster.

In that case the service account used to start the windows clustering service must have access to SQL Server. Usually after you...

Did you read the link provided with the answer?...

S Hodkinson (6/12/2009)

---

I've created the backups and they appear to be running OK (for both simple and full recovery mode). When I come to do a restore of a...

I think in that case your only option would be reading from the transaction log (backups) using a tool like APEX SQLLog. http://www.apexsql.com/sql_tools_log.asp.

Of course that will only work if...

No, not in SQL 2000. You can store xml data...

Could you explain a bit more why you need this information and especially when.

Do you need it real-time or for auditing purposes?

In activitymonitor and when executing sp_who2 you can...

Did you check in replication monitor for any error messages?

Ok, I give it a try.

the guest account is used to give access to a database without explicitely creating a databaseuser for a login. The best example is the mastter...

No. Don't move the msdb. What you should do is script out all your jobs, operators and alerts and thenm...

Duplicate post, please see here

http://www.sqlservercentral.com/Forums/Topic733539-5-1.aspx

Duplicate post, please see here

http://www.sqlservercentral.com/Forums/Topic733539-5-1.aspx

First of all you column must be a nchar or nvarchar column.

When you can do like this:

CREATE TABLE t1( c1 NVARCHAR(10))

GO

INSERT INTO t1

VALUES(NCHAR(8805))

GO

SELECT * FROM t1

GO

DROP TABLE t1

SQL Server 2008 enterprise IA64 is for Itanium processors, so this will not work on a DL380.

For the other requirements see here:

http://msdn.microsoft.com/en-us/library/ms143506.aspx

prsnn_shetty (6/11/2009)

---

Hi,

Can we truncate from [dbo].[sysdtspackages] in msdb since the

table size has grown upto...

manus4u (6/10/2009)

---

Could some one please let me know whether there is any limitation in creating profile names for sp_db_sendmail? or how many profile names that sql server 2005 maximum support?

Thanks...