Using MS SQL Server

SQL Server 2000 SP4 Becomes clogged!!!
I have a SQL Server 2000 SP4 Enterprise Edition with Build 8.00.2039. OS: Microsoft Windows Server 2003 Ent. SP2. 6GB Ram and AWE is enabled for SQL Server to use more than 4 GB. The server hosts some reporting databases where Business Objects execute stored procedures to pull data for these reports. All of a... 20 Jul 2008 21:42

SNL Sql
For those that aren't familiar with SNL it's 'Saturday Nite Live'. It's a tv show that parodies celebrities, politicans, social behavior etc. It's humor with a stinger, it's supposed to make you laugh at that which is just too silly to be taken seriously:) The smiley's say it all. select 0/0 -- :( select 1 ... 19 Jul 2008 18:06

ms sql 2000 - create update script
how to create script - update database development code using MSSQL 2000 Enterprise Manager i'm trying in this way all tasks -> genetate sql script .... ( in this way I can generate only CREATE Database SCRIPT ... ) [ IJKK] ... 25 Jul 2008 12:28

"USE" Command Stopped Working (was: Patch for KB948110 causing random "Could not find database table ID" errors)
Larry Leonard (Larry.Leonard.DSI(a)gmail.com) writes: It sounds scary that the hotfix installed despite that you were only on SP2. Then again, the download pages says "Security Update for SQL Server 2000 Service Pack 4 and MSDE 2000" without any service pack indication for MSDE. Well, I finally di... 18 Jul 2008 17:32

"USE" Command Stopped Working (was: Patch for KB948110 causing random "Could not find database table ID" errors)
> It sounds scary that the hotfix installed despite that you were only on SP2. Then again, the download pages says "Security Update for SQL Server 2000 Service Pack 4 and MSDE 2000" without any service pack indication for MSDE. Well, I finally discovered it has nothing to do with the MS patch – I “ghosted”... 18 Jul 2008 12:21

We have many new activities on the website. PayPal
We have many new activities on the website. PayPal 1st: Integral 1$B!"(BFrom July 1st to August 31, all the registered members will get a free 100 points integral. 2$B!"(BAs long as you pay for your orders, you will be presented with the same amount of integral. For example, if your order$B!G(Bs am... 18 Jul 2008 11:19

SQL Query for Dummies
I'm new to SQL but not Excel I was given a Excel spreadsheet with Employee names. I have a large database with a Personal Table with Employee names and a whole list of other tables that I'm used to running queries. I'm still new to queries. I can run queries using the Pers_Table with employees and other ta... 17 Jul 2008 16:50

CONVERT() problem
In access query, i can use following expression to show "AnyInteger" in the format of "0000" CStr(Format(AnyInteger,"0000")) eg: 12 yields to 0012 8 yields to 0008 how should i use CONVERT() function in SQL SERVER to achive my goal please? ... 25 Aug 2008 14:28

Looking for Ice Products?
Ice at MSN Shopping Save On today's Great-selling CDs, Soundtracks, Box Sets & More. http://a.uuload.com/Ice.htm Official Ice.com Online Store Great selection and savings from one of the Internet's leading jewelers. 30-day money back guarantee and easy monthly payments. http://a.uuload.com/Ice.htm Ice.com Je... 16 Jul 2008 00:40

Latest updates in database management and SQL server tools and techniques
Find the latest updates in SQL server tools and techniques. More details on database management, software testing, flow chart prepartation and many more http://www.sqlserversoftware.blogspot.com Find the hot jobs list in the field of Information Technology http://www.infotechjob.blogspot.com ... 15 Jul 2008 21:36