the messages are in a system table within master, sys.messages or sysmessages ( your choice ) , you'd need to restore a previous master and copy the messages you need...

coming from both sides ( I often get involved in interviews ) I'd pass on one piece of advice - don't put things in the cv that you can't back...

I think most of what could be said has been said. I'm glad we don't exist in a case insensitive world .. !!

yeah -- but I have a possible answer - I've just had a run in with a system architect, who when challenged about GB vs spindles ( they wanted to...

from experience the sort of issues you may face include poor performance!! and that everyone will blame sql server .

The common issues with sans are that the disks are normally set...

when I move work files to archive ( so to speak ) I use robocopy. I'm reasonably well organised having a reasonably good structure in my workplace. I periodically archive...

Monitoring i/o completion time is critical to performance, if this figure rises, typically above, say, 6ms then the disk sub system cannot support the level of i/o requests. I've found...

yup in certain situations the 3GB switch can be problematic, sysmaint.exe, dtsrun, xp_preparexmldoc ( or similar) run outside of sql server process so need external memory - the 3gb switch...

I'm wondering if this is a spoof posting as I'm sure this is maybe the  third time I've seen the same question posted in different ways. There are some excellent...

discipline / get organised ????  I carry my work on cd's with scripts in subfolders under category - 12 years work on one cd !

you can rename the database , but a fully qualified database is known by instancename/database name anyway.

select convert(varchar(128),serverproperty('instancename'))

select @@servername

select convert(varchar(128),serverproperty('machinename'))

e.g.

instance102

myserver\instance102

myserver

add to the database name as required e.g.

select convert(varchar(128),serverproperty('instancename'))+'_'+db_name()

It was explained to me that some of the features of sql server relate to SBS type environments where sql server is not necessarily on a dedicated box. In a...

you can change as many switches as you like in boot.ini but you still have to enable awe in sql server, and you should also set the min and max...

yes, it was only the beta which wanted to be the only one.

if your table variable is working in tempdb then you should replace it with a temporary table which has far superior data handling. Check out ms kb articles for differences...