Hi Andrew,

It looks like you have ansi_warnings turned off in query analyzer.

Check the query analyzer connection properties located in the options dialogue (Tools>Options>Connection Properties tab)

Hi Perry,

There is not yet a release version for express. The November CTP is all they offer, at this time (presumably, a release version wil follow).

The link for the...

Hi,

There is an organization called the International Monetary Fund that posts exchange rates Monday through Friday. It looks like they post US Dollar based rates each weekday to this...

Hi Michelle,

I think that all of your DDL files should probably be under source control. Creation scripts for tables / indexes / views / stored procedures, etc. This...

This isn't built into SSMS. However, there is a free (0.5 relaese) utility called scriptio that you can find here:

http://www.sqlteam.com/publish/scriptio/

I saw this answered in another forum so, I thought I'd provide the URL here so everybody in this forum can benefit, as well...

http://groups.google.com/group/microsoft.public.sqlserver.server/browse_thread/thread/3d3e05ce8ce60090

Hi Crystal,

The builtin/administrators windows group is not required when installing a service pack unless, of course, you are logging in as a local administrator 😉

We routinely remove builtin/administrators from our...

Hi Noman,

Without seeing your DDL, I'd take a wild guess that you put your function name inside single quotes.

Here is a quick and dirty sample that seems to work...

create function...

Yes, the /S is per second.

Your calculations look good but... I'd guess that your file is probably sized using GB. Just to confuse people, storage is typically...

Hi Russ,

Profiler can capture any SQL commands being submitted to the server. By default, it will capture ALL traffic to your server. If you have a busy server,...

Hi Krissy,

Here's my wild stab at it. I left in my notes as I walked through it. Please let me know if I'm glaringly off: CONSTRUCTIVE criticism is...

Looks like I copied your answers. Some of their "correct" answers didn't seem entirely plausible, though.

Hi John,

You could use sp_executeSQL and pass your parameters in separately, withoug worrying about the extra enclosing quotes...

SET @mySQL = N'EXEC usp_MyProc @SchID, @UpdatedBy'

SET @params = '@SchID nvarchar(20),...

Hi Farha Saleem,

You can open the properties dialog in Enterprise Manager and click "Permissions..."

or, you can do it with a query (you'll have to add the schema portion if you...

SQL Server will allow you to run multiple database servers on the same windows server. when you do this, each database server on the windows server must have a...