Um... no, that's pretty terrible.

I like Ninja's example, but you don't need to use vbs if you're not experienced with it.

You can use windows authentication and the -E switch on osql for integrated security....

Yeah, I was kind of hoping that the original poster with my approach could modify it to get what he was looking for. The reason I use my approach...

You could first look at either the Current Activity window or using sp_who to check for existing connections into that particular database. Otherwise you can set up a trace...

Did you do a BACKUP LOG ... WITH NO_LOG/TRUNCATE_ONLY between those times? Or maybe change the recovery model? I believe those could monkey around with the LSN's but...

If I recall comments are extended properties. You can modify them using sp_addextendedproperty, sp_dropextendedproperty, sp_updateextendedproperty and view them using fn_listextendedproperty(). Some tools streamline modifying these, but that's the...

It looks like you have one or more log files that need to be applied in between the full backup and the transaction log backup that you have. If...

Not 100% sure if this is what you're looking for, but use MAX() on the column you want to use as the differentiator. For instance if you want to...

Well only members of sysadmin can start/stop traces so that might be the first place to look. Other than that you could set up a trace to capture DBCC...

Quick and dirty? Change your second query to this...

SELECT getdate(),d.dbid as 'DB_ID', d.[name] as 'DB_Name'

, Count(distinct p.spid) as 'DB_Connections', ISNULL(sum(cpu), 0) as 'Total_CPU', ISNULL(sum(physical_io), 0) as 'Total_IO'

...

Unless you have logging enabled you probably can't.

I'd go into your server properties and under login auditing set it to audit both successful and failed logins.

Look for text of "sp_prepare" shortly before those sp_execute statements... what happens is (if I recall) sp_prepare readies the SQL and stores it temporarily with a numeric handle (that's...

Personal preference... I always try to use procedures rather than letting the application query views. If down the line I need to do other actions and/or check more complex...

I've run into this error before while using linked servers. Are you querying a linked server at all? You may want to check the settings for "Use Remote...

Why not grant to the specific ASPNET user then? Or use impersonation in your application?

I mean, do what you want, but it's usually a pretty bad security practice to...