Jeff Moden has written a couple of great articles on this topic:

e.g. http://www.sqlservercentral.com/articles/Advanced+Querying/61716/

it is a common design issue to just use nullable columns !

DocDesc nvarchar(50), null

Filename nvarchar(25), null

Filepath nvarchar(100), null

InsertDate datetime, null

UpdateDate datetime, null

FK LangID smallint, null

Avoid the...

As Steve stated, it is the sqlserver service account that needs to be granted write access to the path that you want the backup to be written to.

If you are...

Books online states these restrictions:

Restrictions

Because the DAC exists solely for diagnosing server problems in rare

circumstances, there are some restrictions on the connection:

To guarantee that there are resources available for...

In stead of doing the delete... try out your re-load scenario using:

truncate table yourtable

This is the fastesd way of emptying a table and it will reuse the space.

Regarding the log...

did you address the ldf file using UNC ??

Pointing to a remote disk or fileshare ??

it states

the such as is the tricky part overhere.

I would start perfmon and check...

Good advise Ken Garrett ! 😎

Apart from solving the 4Gb problem, the real question should be ..;

Is it considered normal that a single table can consume 2Gb in a size...

isn't it stating a location for the log files it searches ?

Can you post the results of sp_helpdb 'yourdb'

Which is the location sqlserver is trying to write the audit trace file to ?

By default that would be the sqlserver instance \log folder (where you can also find errorlog,...

Ol'SureHand (2/15/2009)

---

Hope this question does not need its own thread ...

Data warehousing practitioners seem to have a constraint on EVERY single column. The above code will only preserve necessary constraints,...

Back in the days we used to use this before restoring an EUC database:

CREATE PROCEDURE sp_DB_SendAndKill

@database char(25),

@contact varchar(100) ,

@reden varchar(300) = ' ** reden werd niet opgegeven **...

Did you try to use "net send" to the windows users or workstation ids ?

However, in some shops they shut of this service.

Or you could query AD to fetch the...

Did you our SQL Server Configuration Manager to perform the service account change ?

if not... change it back the way you did and then use SCM to configure the...

I don't think the view designer shows up in the connection info of the spid.

So I guess you cannot restrict its usage.