Hello,

You have to take into account the available drive space and limit tempdb growth to the appropriate amount of space. I had a case recently when temdb that was not...

Greg,

You have a good site with examples!

I am not really sure what will out perform what. The only thing that I know that both a view and a function...

Antares, lots of sources still say 5 connections for MSDE. Like ChooseEd.Doc white papers (says same as Personal, Personal says 5)

http://www.microsoft.com/sql/techinfo/planning/SQLReskChooseEd.asp

and MSDE 2000 Features at

http://www.microsoft.com/sql/msde/productinfo/features.asp

that says:

It has...

Hi, you will be able to do it in SQL Server 2005 as I understand.

Meanwhile did you try to add it as an extended stored proceedure like described in...

Hi all,

Good discussion! I just want to add that we usually back up databases and those backups are very readable if you open them in Notepad.  Another thing: the backup...

Hi all,

The reason that someone will use Sp is to pass the parameters to the statement like if he needs to select order IDs for particular customer, different each time....

I had one problem 2 times with Hard Drive and 1 problem with CPU on the machine that runs SQL Server 7 and IIS with Indexing Service to let report...

Eve,

I don't maintain master/target architecture at all for the reason that we usually have a "server by project/department " way of doing things. Departmnets like to have a server to...

Jacob, you need to talk to users and understand  their actions. MSDE has a limit of 6 (not 25, but 6) concurrent batches, then the performance goes down. Batches mean...

I am not sure what acounts you are talking about when you say :

Server 1   Using SQL Server authentication for BOTH  SQL Server and SQL Server Agent connections(identical logons, etc)

Server 2  ...

I have another comment on this article. It is very important where you put your backups to. You may backup transaction log every 15 min but your server is backed...

Hello All,

I have a simple script that queries MSDB database sysjobs and sysjobhistory from a simple ASP page. Remove the appropriate quotes if you run it from query analyzer

strSQL = "select...

Hi,  you have spent so much time trying to fix your problem, I would by this time probably re-install. Since your SQL Server is stopped anyway, copy out (save )...

I use sqlredis.exe sometimes. It is downloadable (assuming you have all licensing you need) and also on the SQL Server CD. It is silent install. See "sqlredis Software Distribution Executable"...

Hello,

Yes, there is a way. We had to switch from Exchange to Notes and we lost SQL Mail that requires Exchange server on the network. (By the way, if somebody...