Is there any reason to not use a GUID and or a timestamp in all your tables anyway?

I mean provided storage space isn't an issue, it seems like they are...

That is EXACTLY what I tried, but it failed.

HOWEVER, I was running it against an SQL Server 2000 data source.

That is VERY interesting to know, thank you for that!

I hadn't...

I have to agree, it looks like a stored procedure may be your only way to get that job done.

Which frankly is too bad, as I can certainly see where...

I appreciate the links, thanks!

I thought the default trace was enabled by default on MSSQL 05?

Additionally I thought that server side traces could only dump their data to log files, only profiler lets you...

The interactive height setting ONLY impacts the web based report viewer.

When you go to the Report Manager, run the report, and view it inside your browser.

Exporting the report seems to...

That would be great.

Perhaps everyone could comment on it and a sort of "community accepted" document could come out of it and be refered to in a FAQ or something.

No, but that is our end goal... way down the line.

I just mean to setup a new box.

You have hardware sitting there, and an SQL 05 install DVD/CDs in the...

I never actually changed it in any of the property windows, I would open the report in the code view:

Visual Studio 2005 (BI Studio)

Open the report in layout mode

Click...

SA (1/15/2009)

---

The article is great, but I've read that the SPN needs to be re-registered when SQL is stopped and re-started.

I usually provide the service account read-write SPN privileges on...

Hmm... can I have it both ways?

Can I give the service account privs to do that AND setup my own serverName so you can go to FQDN or servername?

What I'm...

Jeffrey Williams (12/19/2008)

---

To get Kerberos to work, you need to specify one of the SPN entries that was created.

If you just leave it to SQL Server to create...

I didn't realize that about the FQDN for Kerberos.

So in my application's connection string:

myserver is NOT sufficient to get "the job done".

I need to specify: myserver.mydomain.blah.blah the entire path of...

Nope, no port changes, running on default.

I'd wager something is screwed up with Kerberos then, I'll have to start looking around there and make sure everything is working OK.

(Just saw...

Each server only has a single SQL instance.

HOWEVER, I do have several servers all running SQL under the same domain account.

Is that causing problems?