Hi, Im trying to create a publication on SQL Enterprise 2000, using Enterprise Manager. This is on a brand new database, and table, and Im getting...
As Im sure lots of you know, Microsoft are not supporting MSDE on Vista, instead encouraging everyone to upgrade to SQL 2005 Express My question is,...
I have a stored procedure which was modified yesterday. Running the procedure from query analyser today, it wasnt producing the expected results, but...
Im interested in everyones experiences of migrating from sql 2000 to sql 2005. Ive held off from upgrading in the past because the benefit didnt...
Hi all, In enterprise manager its possible to replace the default stored procedure template with another one, simply by copying a file to...
Hi all, Im converting a stored proc which sends query results in a CSV via sp_sendmail. previously the results have been in the body of the...
Hi all, <br /> <br />Im, trying to tune a large stored proc which does lots of calculations. There are about 3 levels of nested loops (and both while...
Hi All, We have a requirement for a part time database developer, based in Leeds, United Kingdom. The candidate will be job-sharing with myself (I...
Hi all<br /><br />I have quite a complicated stored proc with plenty of joins, and then orders it according to various parameters. The fields used by...
We have been slow to migrate to 2005, and are still using 2000 for all our databases. Im curious to know if 2005 supports any ability to provide...
Hi, this is mainly a question to Brad really. Im not sure whether the hyperlinked adverts generate much revenue for the site, but they dont strike me...
SQL 2000 Client tools <br /><br />Quite often when I have several query windows open in Query Analyser, when I close one of them using CTRL F4, the...
Anyone know of a way to install SQL-DMO 8.0, without installing the SQL Server client tools? Im working remotely on terminal services and need...
Two of our servers have started behaving oddly with the diagramming tool in Enterprise Manager. Trying to create a new diagram and saving it,...
Hi, for the life of me I have not been able to post my question here as it contains sql code (an sql forum that inadvertantly disallows sql code <img...
SQL 2000 sp3 - Enterprise Edition - v8.00.760 DBCC SHRINKDB('database') Server: Msg 7959, Level 16, State 1, Line 1 The DBCC statement is not...
Exam 70-019 (Designing and Managing a Data Warehouse on SQL 7.0) was discontinued in June 04. There appears to be no replacement exam for SQL Server...
Anyone used Embacadero change manager? Interested in feedback on the tool and what experience youve had with it. Thanks
More of a pool than a question, but just out of interest: How many experienced dba's here regularly use their own custom messages in sysmessages...
Our SQL servers backup across a 1 gig network connection to a network area. One server received a delayed write failure last night. Hunting around...
Separate names with a comma.
