http://www.sqlhowto.co.uk/post/how-can-i-script-a-basic-backup-task-.html&page=

http://www.sqlhowto.co.uk/post/how-can-i-restore-my-database-in-tsql-.html&page=

http://www.sqlhowto.co.uk/post/how-can-i-design-a-backup-strategy-.html&page=

Hi

There are multiple reasons this can occur. One of them is your network packet size setting:

In SQL Server 2005, when setting the network packet size option to 16,388...

Hi,

Service packs are cumulative. Each new service pack contains all the fixes that are in previous service packs, together with any new fixes. You do not have to install a...

I had to do something very similar and its certainly possible but can get tricky depending on the complexity of your relationships...

For mine I created a temp table of every...

Database mirroring can be used in conjunction with replication to provide availability for the publication database.

http://msdn.microsoft.com/en-us/library/ms151799.aspx

yes it should be stored as an int in this case but should the value range change, you should be aware of the variations:

bigint

Integer (whole number) data from -2^63 (-9,223,372,036,854,775,808)...

this should help...

http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1197403,00.html#

Hi

The first cumulative update generally available is CU1 (build 9.00.3161):

http://support.microsoft.com/kb/935356

The most recent is CU10 (9.00.3294):

http://support.microsoft.com/kb/956854

I don't think you can get 3073 unless you contact PSS...

I see what you mean... other option is you could add a check for the day before deciding whether it runs or not...

If (select DATENAME(dw,getdate()))<>'Sunday'

BEGIN

--its not sunday so run...

If you start a job at 2345 hrs on a Saturday, anything longer than 15 mins will run into Sunday morning. You could have one job to do Mon-Fri and...

That error is often linked to permission probs.

http://social.msdn.microsoft.com/forums/en-US/sqlsecurity/thread/59ade8de-1c74-4acc-b20d-2e8f9f7ad2c2/

no, never seen that either. Just double checked the syntax for views and theres no mention of % (other than for use as a wildcard)

http://msdn.microsoft.com/en-us/library/ms187956.aspx

excellent, glad to help 😀

I passed that one about 12 months ago... if its the same then the exam is split with multiple choice and scenario based questions so you will need to know...

You might just want to check how your other network apps are performing?

and also, have you any other databases? how are they performing?

Then'd i'd start running a trace...

Let us know...