Hello,

I'm not sure what the issue is, as the following works on my SQL 2005 Instance. (Okay the Column DataTypes need correcting, but this was just a quick test).

Use tempdb

Go

/*...

One more thought …

Are the Client Application's Users Windows or SQL Logins?

If they were Windows Logins, you could consider adding a Local Group on the Windows Server and then assigning...

Hello Again,

Another thought - in SQL 2005 there is the "Execute As" Clause which would allow the SPs in you satellite DBs to execute under the context of a single...

Hello Again,

I don’t have any benchmark figures, but we use (SQL Server) Linked Servers to separate Instances on the same Windows Server, without any performance degradation.

I wonder though if you...

Hello,

I'm not sure exactly if I understand your question correctly, but I was thinking that may be you could set up the Central DB as if it was a Linked...

Hello,

Did you try to Drop the Non-Clustered Index and then Add the Clustered Index e.g.

ALTER TABLE dbo.Table1

DROP CONSTRAINT PK_Table1

Go

ALTER TABLE dbo. Table1 ADD CONSTRAINT

PK_ Table1 PRIMARY KEY CLUSTERED (Field1)

Regards,

John Marsh

PS:...

Hello again,

Below is a more general purpose, instance-wide script that I once downloaded. Unfortunately, I can’t remember where from, so I'm unable to give the author his or her credit.

Regards,

John...

Hello,

I noticed that GilaMonster's scripts need a slight amendment to the Where clause along the lines below, when run on a case sensitive database - yes, some do still exist!

Upper(xtype)...

Hello,

You can find which objects have Clustered Indexes from sysindexes e.g. Select object_name(id), name From sysindexes Where indid = 1

(Please note that this query returns system objects as well as...

Hello,

Is their test machine inside their Firewall?

Do you have a Firewall on your machine? If so, when you get the Port Number from them, you need to ensure that the...

Hello,

Can you try specifying the Port in the connection string i.e. Ip-Address\instance-name,NNNN

(Where NNNN is the Port that the ISP's SQL Server Instance is listening on. BTW - I am assuming...

Hello,

When you say "Sql Client" do you mean you need the .Net SQL Client Assemblies or the SQL Client Tools e.g. SSMS on your (application) Server.

In the first case you...

Hello again,

I should also have mentioned that if you don’t want to change your settings, you could use the IsNull function in the Join e.g. On IsNull(Table1.Field1, 1) =...

Hello,

From BOL:-

The SQL-92 standard requires that an equals (=) or not equal to ( ) comparison against a null value evaluates to FALSE. When SET ANSI_NULLS is ON, a SELECT...

Hello Priyanka,

Mr. McKinney has just pointed me to this article: http://hosteddocs.ittoolbox.com/KG051507.pdf

It explicitly states that you cannot use sp_xml_preparedocument from inside a UDF.

If you need it to be a...