http://support.microsoft.com

Clive Strong

clivestrong@btinternet.com

Just a quick point following on from Andy. By deleteing the log and then running sp_attach_db and only supplying a data file to be attatched, a new log file...

If your DB & Logs are being backed up, then after the TLog has been backed up, this should free up space in your log file and leave only the...

Hi,

Curious indeed! How is the data being imported from Excel into SQL Server? Are you using a DTS or are you using code to read from Excel and...

Have you given "CREATE TABLE" permissions?

If not add the user into the database. In EM, right click on the database and select properties. Choose the permissions tab and...

MDAC 2.7 is the latest (same as on XP).

You can download from

http://www.microsoft.com/data/download.htm

Clive Strong

clivestrong@btinternet.com

Hey Andy,

I had a hunch on this one that the login was part of a Domain User group. Not sure why that account was put in the Group.

Should Domain...

Hi Kelvin,

I know your situation well. I was faced with this same task!

My first step, would be to run a trace on your database using profiler.

Typically, when tracing for...

Hey,

Just to follow on from this NULL user issue and save creating a new post. I am slightly baffled with something.

We have a user set up as System Admin....

The syslogins table is in the Master DB. Open Query Analyzer and run it from there. I could not see it in EM either. I presume it...

Sorry...typo there!

The 3 statements should be in the "TextData" filter and in the "Like" dropdown filter!

Clive Strong

clivestrong@btinternet.com

Hey,

If you only want INS, UPD & DEL statements, I'd do this..

In the "Events" tab, keep only TSQL->SQL:BatchCompleted

In the "Filters" tab, set

DatabaseID or DatabaseName

And also in the "TextLike" filter inlude...

Hey,

Can the Linked Server not be a permanent? Or is this an issue for your company?

If you could have a permanent Linked Server, this would resolve your issue

If you...

Hey,

With regards to the installed SP...Is this SQL2000? If so, run the following command.

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

For SQL 7, check the following link (too lazy to...

Hey Robert,

Thanks for your feedback.

All of our servers are hardcoded with the Server Name. I was just playing about with the (local) parameter yesterday.

I like your idea of the...