Can I add a related question?

If access is granted through Windows NT Security and I appear in a couple of different groups, with differing Default Databases... is there any rule...

Hi,

Is the Analysis Services server registered within Analysis Manager on the PC that is being used to create the DTS package? The list of Analysis Services servers in the...

Thoroughly recommended. Well written and easier to read than many, without being 'Noddy'.

It's a British book, that's why it's not so popular.

One of the limitations of Functions is that they cannot store data in permanent tables.

Is this the case also with OPENDATASOURCE and OPENROWSET?

My pre-lim enquiries suggest that this you cannot...

Re-opening an old topic here, but I've just found this post as I've been looking for a way of using OPENROWSET to open a text file.

I have been trying to...

As you'd probably gathered, this was the first thing that I tried to do.

The only other thought that I'd had so far would be to try to 'intelligently chop the...

Thanks for the responses.

The Log does not appear to be clearing at all after a Full Backup is taken - i.e. it stays at around 95% (though a TRUNCATE LOG...

Andy,

There is only one index on the table (the Clustered one).

I may end up leaving the database at the enlarged size, but the trouble with leaving space, of course, is...

Thanks Andy, I'd kinda worked that out from my findings.

I'm a little frustrated that in order to de-frag the table...

o I'm expanding the database (just for that purpose)

o Then re-indexing...

Can I re-open the problem?

Further checking has shown that the table is fragmented once more.

I have done a number of little experiments on this and I believe it to be...

Many thanks for the comments.

I upped the Maximum Sizes on Database and Log Files, switched to Simple recovery mode and kicked off a DBCC DBREINDEX.

All complete in about 30 minutes,...

These tables appear to be truncated too:

syscolumns - OK as far as language, later columns missing

SELECT * FROM information_schema.columns

Returns

Server: Msg 207, Level 16, State 3, Procedure COLUMNS, Line 5

Invalid column...

Sounds like it might be waiting for a lock - sensible in my opinion as the data isn't actually in the database at that point.

If you can't read...

Wow - what a great response!

Just to clarify a few things...

The work that will be performed on the Server is Reporting from a number of other systems. Some will...

I'm currently considering setting up a second (development) instance on a SQL 2000 system.

The system is pretty hefty (8 processors, 6Gb RAM, 1Tb) and we have a massive amount of...