Usually when you copy a text of length>256 characters and paste it to a cell in excel, it truncates the text to the first 256 characters.

However, if you manually enter...

try to introduce a delay between each consecutive steps and keep it under observation.

waitfor delay '00:00:30'

can u manually try to perform each step and observe the sql error log?

1. Are you querying your table to get that output?

2. What do you mean by program in this context?

3. I tried pasting Gretzsky’s to notepad and it remains as it...

Check with the application developer.

He must have replaced all entries of single quotes with this character.

Usually programmers substitute single quotes with some other characters while writing to tables and...

Everything is fine in the SP which seth has given

Only thing is i donot want to create #a like below

CREATE TABLE #a(

...

Did you run this query written by Chris? what was the...

Thanks for Clarification Adi.

I get so much learn here 🙂

sowmya.br (12/16/2008)

---

Hi Seth

i tried this but after exec of sql, when i try to do select * from $a, it throws error saying #a does not exists in database....

If you're thinking of restoring old mdf/ldf files, you'll lose data that was changed after that old cold backup.

If losing data is fine with you, you can do that.

or as...

Refer http://www.sqlservercentral.com/articles/Basic+Querying/temptablesinsqlserver/1279/

If number of connections is 1, even the global temp table wont be of much help as the table will be dropped if that connection is lost.

You...

Doesnt seem to be an excel issue.

see if you can find some resolution from

http://social.msdn.microsoft.com/forums/en-US/sqlreportingservices/thread/973e3546-3f52-4d1e-b370-6af79a4c3c53/

there are too many doubts. First of all, is there only one conference hall? If not, Is there a relation between citiID and LocationID? What are you trying to store...

I want a stored procedure for booking a conference hall.

we are taking the from date and to date from the user .Need to show the available timings for that particular...

If you're able to startup OS in safeboot mode, check the sql server servcies status.

1. If its not running(or you are unable to start sql server), copy all the...