I would say, any place where you need to reference to the db name, there might be a potential issue. Such as BACKUP, RESTORE, maintenance... Butr it should be safe...

INSERT INTO ... EXEC sp_helptext would be another option.

but the contents i want to store in a variable so that we can store them in the table.

What do you mean...

As has been already said, when you have a date stored in a DATETIME column, you are always able to use SQL Server's built-in functionality to get the dayname associated...

Hehe, reading through this responses, it reminds me of http://www.sqlservercentral.com/columnists/sjones/funny38.asp

Okay, networking is to a certain degree a necessary evil (to me). Most of the folks here who joined PASS seem to be self-employed lone fighters. For them it is...

My, oh my, I didn't want to make it public.

Anyway, thanks to all.

...and yes, she's soooo cute. Two days old and already...

As you already have found out, this is handled differently in SQL Server and Access and Oracle (I believe). A UNIQUE constraint here allows one, and only one index key...

XP on the laptop. Windows ME on the other one's. I used to run Linux on my home computer's, however now my elder son will start school this year and...

...forgot to add.

It might be a German specific phenomenon, but it's even hard to build up a German SQL Server online community, it will be much harder to establish...

Hard to tell. I'm really unsure about the meaning behind user groups right now. I suspect them to be kinda outdated for information retrieval, but it is fun to actually...

Why should this be "perverse"? When you have a single mdf file and spread this over multiple disks, all table and indexes will benefit equally from. However when place a...

Yes, there is a workaround! Avoid using numbers for identifiers in the first place generally in SQL Server.

Another workaround might be

USE [2test]

GO

DBCC SHRINKFILE ([2test_log], 1)

Note the [ ]...

EXISTS() will almost certainly be faster than COUNT(). EXISTS can stop once it has detected one single row that matches the condition and returns TRUE, while COUNT needs to run...

Actually, the fact that Yukon will move this issue from pseudo-compiled T-SQL code into machine code, doesn't make the whole thing more the job of the server. I think, this is...

There is actually a limitation on columns in a table: 1024. So, way to go here. Generally I would agree with you, that 245 columns are pretty much for a...