Can you also post the query

Hi,

Did you clear your windows log and resolve the SPN issue. We can go further into debugging this issue if you can do these two things.

Hi,

But keeping your files in C (which is a system drive) is not at all recommended.

Hi Shiv,

SPID is a unique id number given by sql server to uniquely identify user connections. It is not stored in any of the databases.

for better understanding...

Hi Suresh,

Please post the create scripts for table structure,index and sample data and also the query execution plan. If you have only 20...

Try this

Create Procedure dbo.GetLastID2(@Table_Name varchar(25))

As

Begin

DECLARE @sqlString varchar(100)

SET @sqlString='select top 1 id from '+@Table_Name+' order by id desc'

EXECUTE sp_executesql @sqlString

END

GO

Hi,

Can you post the query execution plan.

Hi,

As you can see there are lot of errors in the error log.

FCB::Open failed: Could not open file D:\PROD\MSSQL.3\MSSQL\DATA\model.mdf for file number 1. OS error: 32(The process...

Hi,

Whenever you get any error you need to check two things.

1. Is there any error in sql error log.

2. Is there any error in windows event...

Hi Madhu,

I think MS supports both enterprise and standard on a single server if your software is legally purchased. But when you have...

Hi Vinod,

I am working for past 4 years as sql dba. I had seen many of my team members(oracle dba's) (even who are from other...

try using

right('XXX - P12336',len('XXX - P12336')-6)

I think you can use any of these

SELECT HOST_NAME()

you can check out clusteradministrator

Per my understanding,if we are installing the SQL Server Through the SQLcmd prompts without having the SSMS, then only it can have allow to install the "Named Instance" directly for...