ELSE cannot be used that way.

I can only be used in CASE statements.

I guess you need OR here.

What are you trying to achieve with that "ELSE"?

Welcome

Try with table aliases:

SELECT *

FROM [LinkedServer].[DBonLinkedServer].[dbo].[Sales Price] AS remotetable

WHERE NOT EXISTS

(SELECT localtable.*

FROM [LocalDB].[dbo].[Sales Price] AS localtable

WHERE (localtable.[Item No_] collate Latin1_General_CS_AS = remotetable.[Item No_]) AND

(localtable.[Unit of Measure Code] collate Latin1_General_CS_AS =...

The variable @@servername may get empty when you rename the windows machine.

I've also seen it happening in other situations but don't remember how.

However it's safer to use SERVERPROPERTY('Servername') rather than...

BCP out and in is the quickest option in my opinion.

Use the native format (less pain involved).

What about revoking permissions to everyone but you on the trigger?

Another option is setting up a database mail alert for changes on the view, so that you're notified right away,...

Just add a check for the database name you want:

$ServerList = Get-Content "C:\ServerList.txt"

$OutputFile = "C:\Jobs\Output.htm"

$HTML = '<style type="text/css">

#Header{font-family:"Trebuchet MS", Arial, Helvetica, sans-serif;width:100%;border-collapse:collapse;}

#Header td, #Header th {font-size:14px;border:1px...

Your best option is BPC the data out using native format and then BPC in.

You will have to disable FK contraints if you have any.

I suggest that you decide a...

In SQL Server 2000 your only option is a trace.

Not easy: you would have to set up a trace that captures all T-SQL activity on that table (filter on TextData...

Sorry, I misread your question.

You just need to uninstall from control panel.

However, I would never reuse the same cluster for something else after uninstalling SQL 2005. I would rather go...

Here's a good walkthrough:

http://www.mssqltips.com/sqlservertip/1687/install-sql-server-2008-on-a-windows-server-2008-cluster-part-1/

Here's a good walkthrough:

http://www.mssqltips.com/sqlservertip/1687/install-sql-server-2008-on-a-windows-server-2008-cluster-part-1/

SQL Server 2005 is a bit different, because you don't have to install separately on all the nodes (the setup process runs in background on all nodes).

I'm not sure the EXECUTE...AT construct was available in SQL 2000.

Concatenate the parameters and use OPENQUERY:

DECLARE @ICVR_CLAIM_NBR VARCHAR(19)

SET @ICVR_CLAIM_NBR= 'XXXXXXXXXXXXXXXXXXX'

DECLARE @sql varchar(100)

SET @sql = 'SELECT * FROM OPENQUERY(EXCEEDPP,''call PPSPCOL.X2COVSEL...

What do you mean? The users that have access to it? The users that created it?

Duplicate post. Replies here please:

http://www.sqlservercentral.com/Forums/FindPost1614540.aspx