SPN Stands for Server Principal Name

You can get more information for this given below link

http://msdn.microsoft.com/en-us/library/ms677949(VS.85).aspx

When...

MAK-1128556 (12/14/2009)

---

SQL Linked Server Query failed with “Login failed for user , I try every thing, but still no luck.

I try different user still logon failed.

I can get the data...

rockingadmin (12/17/2009)

---

hi

we have planned to migrate sql server 2005.i have around 50 backup files. i want to restore databases using those 50 backup files. restoring individual...

Can you run this query and post the results? If restore is still happening this query will give us details what exactly is happening.

select s1.session_id,s1.command,s1.percent_complete,s1.wait_type,s1.wait_time,s1.wait_resource,s2.text from master.sys.dm_exec_requests...

Hi Dave,

If you look into the log, it says it has some persmission issue for copying for that reason copying job is failing, look into that fix it and...

Please post the errors that backup job is throwing.

Please post the error that it throws when

restore job fails?

sqlbuddy123 (9/9/2009)

---

Hi

Could any one tell me the steps to move the Distribution database from one drive to the other i.e moving from the default...

I think this is default one.

I...

luckysql.kinda (8/15/2009)

---

I am using Litespeed 5.1. I want to use this for object level recovery.

When I try to 'Read a Backup File option' which is a prerequisite of 'Object Recovery...

open the desired location in windows explorer and source in another window in explorer then copy and paste.

Shrink the log file with emptyfile option for the one which you want to remove and then you can remove it using alter database statement.

You can carry out this when...

I use the given below script to get the details of what you have requested.

set nocount on

DECLARE @sql NVARCHAR(1000),@mindbid smallint,@maxdbid smallint

declare @dbname nvarchar(50),@dbid int

declare @test-2 table(slno int identity,dbid...

Indianrock (8/12/2009)

---

Starting with just one MDF, we added four file groups and partitioned out the data based on client type with one new NDF file in each of the new...