Also, with regards to the comment about backups being .bak. By default, yes, but you can call the backups any extension you want.

You can also use DBCC SQLPERF(LOGSPACE) to...

The transaction log file?

What are the extensions of the files in the data and log folders? If the 47GB file is .ldf, it's your database transaction log file.

You can...

SELECT SD.[Name], COUNT(1) AS [Users]

FROM master.dbo.sysdatabases SD INNER JOIN master.dbo.sysprocesses SP

ON SD.dbid = SP.dbid

GROUP BY SD.[Name]

I've not actually used log shipping out of the box, although I have used a version of log shipping which was written using VBScript so I guess it runs along...

Pretty awesome.

Glad you get so much out of the site. It is the coolest site on the web for SQL Server resources. I've been around here for 7...

Congrats dude! 🙂

Have you manually checked the indexes & stats in question? You can see them from the execution plan.

Any significant fragmention in production?

Also, have you run sp_autostats against the table(s)...

Hey Steve,

Domain account at my end.

You can query the sys.objects catalog view for creation date as well as last updated.

You can also query the sys.sql_modules catalog view for the definition.

A good 3rd party tool would...

I probably had 1 (or 5) too many Guinnesses by the time it got to the first dance. It was only a couple years ago, but I can't remember...

You can also view the execution plan from SQL Server Management Studio.

Paste the stored procedure or query into the query window. Right click in the query window and choose...

Hi,

Thanks for the reply. The snapshot agent was not set to run over and over.

I have fixed it now though. The settings for copying the insert, delete and...

Still not advisable, no.

Two of the golden rules around security are to ensure you have a non default port number and ensure that you have a strong SA password.

When you run the stored procedure from Query Analyser, does it return the correct recordset?

It's been about 4 years since I've used VB so I'm not too sure about the...

mick burden (8/22/2008)

---

Clive, can I impose on your knowledge once more? in the line

exec('if exists (select 1 from ##my_table where [' + @column + '] = ''jim'') insert into ##field_name(field)...