Strange question for a SQLServer forum, but the short answer - no, you can't! (Well, not easily!)

You could backup the database and then restore it into itself. This will...

It's best not to relocate the log file using detach/attach. Try using the ALTER DATABASE MODIFY FILE ... command instead

ALTER DATABASE northwind MODIFY FILE (name = 'Northwind_log',

FILENAME =...

I agree entirely with Richard.

Firstly, only shrink datafiles if you absolutely need to (and I accept that it sounds as if you do need to

SQL Agent should handle almost everything automatically.

Consider:

1) You have a job scheduled to run hourly, at 5 minutes past the hour.

At 01:05, it runs normally and on completion sets the...

It is only possible if your PK constraint is NON-clustered. If your PK is clustered, then it and the clustered index will be one and the same thing.

I'm also...

Right - I've fixed it - although I'm still puzzled...

As above, the CFVD\SQLServerService account (the local account) is mapped to pddev (remote account).

Local SQLServer Agent is running as ...

OK Colin - I see where you're coming from now

BTW - I did attend Kimberley Tripp's Reading seminar - fantastic! "Inspiring" is...

Bummer!

Another thought - what account is the JOB running under? If you have another job that IS writing successfully to this...

Hi Carl,

There are 2 levels of permission on a share. When you say Administrator has FULL control, which bits of the Share properties are you checking?

Check the Security tab...

Merrill,

I found this suggestion on another forum:

"I have encountered the same error while executing a simple Insert query - I wouldn't know how to begin to re-write it to make...

One more thing ...

Don't simply accept the argument that indexing a boolean column is a waste of time. It can be a very valuable index! Like any other...

Hemant,

If you're using Developer edition, this should automatically use the View without a hint (it's the same optimizer as Enterprise Edition). I think Eddie was checking that you weren't...

Dan,

As far as I'm aware there should be no difference in performance when selecting from the view or the main table.

I set up a test as follows:

CREATE view testview as...

The required time to grow the database won't be cumulative, as long as you increase by a fixed amount each time instead of a percentage (which WOULD be cumulative).

Does the...

Hi Mary,

It does indeed sound as if collation is your problem. Check this link to an article by Kimberly Tripp:

http://www.sqlskills.com/blogs/kimberly/Default.aspx#a7b4c9796-66d0-4ed2-b19d-bef6bb1e3e1d

This also contains an internal link to a script which...