Thanks, I will set up an agent job checking that then, but then I won't be able to see who changed it, I will only be able to see that...

Hi Guys,

Thanks for the feedback.

I did it on a test server and just want to share my experience.

This should never be done on a production server. When you change...

Thanks for the link and all the advise. I will be making more frequent log backups, but I will go through that ebook.

Hi Guys,

Thanks for the great advise.

The only reason I am making the backups more frequently(Daily) is to manage the size. At the moment they were only making it twice a...

Yes I will.

Thanks for all the suggestions I appreciate.

I have no more details since its not a situation I am facing at the moment.

It is just a question I have to answer.

I am just trying to determine if...

Hi Guys, I have thought of the concurrency issues on the querying side.

If the network is fine would there be any other reasons for time out issues on connection?

Hi Guys, I have thought of the concurrency issues on the querying side.

If the network is fine would there be any other reasons for time out issues on connection?

Hi BLOB,

I don,t want to just play around with code or creating maintenance tasks, I want to set up Availability groups and mirroring and so on.

I have been on the...

Thanks.. I was just wondering, so that won't happen then.

I should have explained from the start what my idea is, sorry. I want to place a batch file on a users PC, that does not have access to SQL...

No, it is a shared folder on my machine. Should I change it to the shared folder address and then try to run it from my machine?

The only thing in the batch file is

-S Servername\InstanceName -i D:\Path\SQLCMDImport.sql

And then to move the file to an archive folder.

SQLCMDImport.sql executes a stored proc that looks like the following:

INSERT INTO...

The DB is on an Express edition so I can't use Profiler. Will do some research to look for alternatives.

There are no triggers on the table, and I am sure it is from this statement, I was testing it first without putting it in a stored procedure.