You can try this one: http://sqlserverbuilds.blogspot.com/

Also, Steve is doing a great job on: http://www.sqlservercentral.com/articles/Administration/2960/

HTH

Robbert

Connect to the sql server using management studio.

Then right click on the database where you want the data to be imported (or create a new one)

Select tasks/import data. Select as...

Have you enabled compression on this folder?

I got the same error in the past on comressed folders.

HTH

Robbert

Try this query, it gives all the auto-growth events in the last day.

SELECT CAST(TE.[Name] as VARCHAR(20)) as Name,CAST(I.LoginName as VARCHAR(20)) as LoginName,CAST(I.SessionLoginName as VARCHAR(20)) as SessionLoginName,CAST(I.DatabaseName as VARCHAR(20)) as DatabaseName,

...

For a more detailed log, this is what you can do:

- Right click on the job, select properties

- In the "Select a page" window, select "Steps"

- Click "Edit"

- In the...

Kyle,

I use this procedure as part of my dbhealth check.

For newly created databases (with no checkdb done) I found that the value for dbi_dbccLastKnownGood is the same as the value...

Do both instances use different port numbers?

Also: http://www.sqlservercentral.com/articles/Security/66151/

Mischa,

Look for Logon Triggers. You can use this kind of trigger to perform an action as soon as a connection is made.

hth,

Robbert Hof

When creating a Maintenance Plan choose "Create a backup file for every database" in the "Back Up Database Task" dialog.

Now SQL Server is adding a timestamp to your backup...

I have the same experience, no 2009-01-30 00:00:00:000 in the result set.

According to the explanation this is correct behaviour.

Nice excersise though, this was new to me.

Robbert

The N'A' means that 'A' is an Unicode string constant.

Unicode is using 2 bytes to encode each character.

The DATALENGTH function returns the number of bytes used to represent the expression.

So...

I used BOL (April 2006) installed on a workstation it says:

Bring a filegroup online.

You can bring a filegroup online in the source database; however, this does not affect its existing...

Adding an extra user to the group did not help.

(I added the local administrator).

The same behaviour when adding another group containing the same user.

MBSA only allows permissions set to an...

If you did not update your books online then you missed this one:

5 December 2005

New content:

Added limitation about using database snapshots with log shipping.

Added a note about...