An example of one of the tables that I'm looking at as 2 indexes:

index_level avg_fragmentation frag_count ...

Finally an answer!!!

Here's my solution:

o On the SQL Server - add the cross-domain account as a local administrator

o Log on to the SQL Server using the new cross-domain account

o Add...

Yes... the requirement is: to pass from a URL a hidden external parameter into the report. There are other parameters which the users will be adding as filter criteria but...

Tell you what... humor me - we have other reasons for managing data in this fashion. I'm looking for a technical discourse on the topic of using a trigger to...

Steve - per my previous posting: I'm getting one error now - sp_addremotelogin cannot be executed within a transaction.

The remote server is SQL 2000 SP4 (the local server is also...

OK - I'm getting a bit closer. I modified the AFTER INSERT trigger to an INSTEAD OF INSERT trigger (code below). Now the new row gets inserted into the table...

Hi Beth -

The whole issue for us came down to the way in which the certificate was installed on the Report Server. Once I got that straightened out the...

I've changed the code over to use linked servers and dynamic SQL. The stored procedure code is encrypted.

We're done...

I've got 40+ SQL Servers and I want to make the distribution of the the stored procedures encapsulated and portable - therefore the dynamic linkserver creation/drop.

The central natrue of the...

DOH....

The answer to my rather stupid question is to use dynamic SQL which will delay the need for the linked server resource until runtime.

Thanks all!!!

Glenn

OK - under the category of: nothing is ever easy...

I'm trying to create a dynamic linked server from within the Stored Procedure that...

I check the Disallowadhocaccess (see previous post). It is set to 0.

==========================

I've decided to abandon the use of opendatasource, opendataset, openquery....

There's simply too much variability and risk. I'm...

The SQL login being used for the opendatasoucre is secured to a single database, single table w/insert, update and select permissions on the table.

So... I've been able to select...

No - there is no firewall. All of the SQL Servers involved are within the private network/same domain.

Does anyone have any experience with using the opendatasource MS SQL function who...

I would assume that since the majority of servers (both 2000 ans 2003) can access the target server (Windows 2003 SP1/SQL 2000 SP4) via opendatasource that DTC is accessible on the...