Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sqlvijay
Starting Member
16 Posts |
 Posted - 2008-12-05 : 11:17:00
|
| Hi Guys, I am new to SQL SERVER. In my production database(sqlserver 2000 on windows 2003) some of the daily jobs have been failed, In our job we have the below query as one of the step. When this step is executed we get the below error.SQL SERVER DOES NOT EXIST OR ACCESS DENIED.herewith i have pasted the select statement.select DatabaseID, cast(datepart(yyyy, getdate()) as char(4)) + '-' + case when len(cast(datepart(mm, getdate()) as varchar(2))) = 1 then '0' + cast(datepart(mm, getdate()) as char(1)) else cast(datepart(mm, getdate()) as char(2)) end + '-' + case when len(cast(datepart(dd, getdate()) as varchar(2))) = 1 then '0' + cast(datepart(dd, getdate()) as char(1)) else cast(datepart(dd, getdate()) as char(2)) end , 'Y', ins.InstanceIDfrom DAASDPS.DataServices.dbo.SQLDatabase as db join DAASDPS.DataServices.dbo.SQLInstance as ins on (db.InstanceID = ins.InstanceID)where db.DatabaseName = DB_NAME() and ins.InstanceName = CONVERT(varchar(30), SERVERPROPERTY('servername'))Thanks in Advancevijay. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-07 : 05:30:32
|
| is DAASDPS a linked server? have you tested the linked server to see if its accesible?http://msdn.microsoft.com/en-us/library/ms189809.aspx |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
|
|
sql server does not exist or access denied