Did you entered a username/password when you started SSMS and connected to the SQL instance? If so: you're using a SQL...

Like others I've found some good answers on SO. But I prefer the forum here on SSC. A question can't always be answered in one single way. Everybody knows the...

What is the info about the LSN's of the TRN-files tat you're trying to restore when you query the tables [backupset] and[backupmediafamily] from the [msdb] database (on the instance where...

I use a script (created by Omri Bahat, see: http://sqlmag.com/t-sql/plugging-gaps-sql-server-job-tracking) to find jobs that haven't run according to their schedule. Allthough this scripts investigate the past, you probably can modify...

Your post is hard to understand. Could you rewrite it a bit, so we (without knowledge of your system / settings / etc.) can understand?

If you can't find the TRN-file...

Answers:

1. A growth setting of 300MB is most probably acceptable. It depends on your disk performance if it can handle the I/O at that moment. If you assign the "instant...

Does your Windows account has the required permissions on the database? Did you run the code in SSMS using your Windows account or did you use a SQL account?

Can you...

I'm sorry. I have misread your the results in your Original post. My first solution didn't gave you the results you needed. The code below does it better. Keep in...

Talib123 (1/17/2014)

---

I'll read through all of this later but the Environment is too large and too much going on to test backups regularly. 150 + Servers. Just one DBA.

99% of...

If you can't figure it out (you don't know which instances are installed or don't have access) you could use ProcessExplorer from Sysinternals to see which process is locking the...

How do you create your backups? Do you use a GUI or do you use code?

If you use code then you need to see if the verify option is used....

A simple SUM on the qty column combined with a GROUP BY on the others will do it:

select date, pallet_movement, sum(qty) as total_qty

from table_name

group by date, pallet_movement

It is not allowed to use the USE statement inside a stored procedure. The only solution to do this is by using dynamic SQL.

create procedure usp_change_db_context

as

begin

declare @dbname sysname

declare @sql_use_db nvarchar(200)

declare...

That's not hard to find on the MIcrosoft website:

http://download.microsoft.com/download/5/3/D/53D72434-7BD5-41C6-A806-8212C1B0DCA1/SQL%20Server%202005%20to%202008%20Upgrade%20White%20Paper.docx

Without knowing the password it is not possible. Your only options are to ask your Windows admins for the password or try to extract the password from DD.