EXEC sp_MSForEachTable ‘ALTER TABLE ? CHECK CONSTRAINT ALL’

Run EXEC sp_depends 'Table_Name' to check the objects referred to the table

Thanks.

Looks like NOT NULL in SQL Server if only use single "?", I mean LIKE ?

Yea. but I didn't use "LIKE ?".

How to use "?" ?

master..xp_cmdshell 'ipconfig'

GO

SELECT SERVERPROPERTY('ProductVersion') AS 'ProductVersion'

GO

DECLARE @chvDomainName NVARCHAR(100)

EXEC master.dbo.xp_regread 'HKEY_LOCAL_MACHINE', 'SOFTWARE\Microsoft\Windows NT\CurrentVersion\Winlogon', N'CachePrimaryDomain',@chvDomainName OUTPUT

SELECT @chvDomainName AS DomainName

GO

DECLARE @tcp_port nvarchar(5)

EXEC xp_regread

@rootkey = 'HKEY_LOCAL_MACHINE',

grahamc:

Could you offer the detailes please?

Thanks

Adiga & Adam:

Thanks for the reply.

I remember there are 5 log files on SQL Server 2005. Could you offer other three and default location like SQL Server Engin error log...

Nary:

I think so. However I wish I can do something on existing databases.

Thanks

Leo & All:

I got the solution and would like share it with all.

At begining, I setup a linked Server (LinkedServerB) on ServerA. This linked server was mapped from SA to...

Adiga:

Thanks for the reply.

I setup the linked server by,

1) Right click "Linked Servers" - New Linked Server

2) Linked Server: SQLServer2000

3) Server Type: Select SQL Server

4) Security:

click Add

Local Login:...

Ben:

Could you explain the details please?

Thanks.

I have the same problem. I changed BAK to bak, then it works.

Suppose you have email profile name, please run this qurey under msdb:

select a.Name Mail_Profile_Name, s.port

from dbo.sysmail_account a INNER JOIN dbo.sysmail_server s ON a.account_id = s.account_id

WHERE a.Name ='Your Mail...

I am not sure the architecure of your applications. But this script can offer the machine from SQL Server side:

SELECT 'MachineName', SERVERPROPERTY('MachineName')