Viewing 15 posts - 5,221 through 5,235 (of 6,105 total)
You may take a look at the Transact-SQL Cookbook published by O'Reilly. It's available online through Safari (http://safari.informit.com or http://safari.oreilly.com). Chapter 2 covers the handling of sets, which is applicable...
August 5, 2002 at 1:50 am
I'm assuming you are running the DTS package from SQL Server Agent based on the error message you've given. Is the SQLServerAgent service running under the same account on the...
August 5, 2002 at 12:38 am
Using COUNT(*) as you have is a typical way to get full intersection when you have a structure similar to the way you do. Is there a reason why you...
August 5, 2002 at 12:29 am
Please do not cross-post. This is a topic that does belong in Administration. As a result, I have locked this topic in the General forum.
K. Brian Kelley
August 5, 2002 at 12:19 am
You don't have to use TempDB. The poster was using it as an example. One of the advantages of TempDB is it gets rebuilt when SQL Server is restarted. Therefore,...
August 4, 2002 at 9:35 pm
The version of MDAC with SQL Server 2000 is 2.6. The version that shipped with Windows 2000 is 2.5. So it's failing on the update. What you might try is...
August 4, 2002 at 9:33 pm
Enterprise Manager and Query Analyzer are both part of the client tools for SQL Server. I'm not up to spec on what typically comes with MSDE, as we don't use...
August 4, 2002 at 5:37 pm
If I remember right, MSDE doesn't come with the SQL Server Enterprise Manager. I believe we installed Office Server Extensions to give 'em a run and of course it dropped...
August 4, 2002 at 3:09 pm
If you put in the SQL 7 CD, you have the option to install the client tools.
Enterprise Manager itself is actually a .msc file that requires MMC. For SQL...
August 4, 2002 at 11:01 am
A table preceded by ## is a global temporary table. The problem with using a local temporary table is it can only be seen within the stored procedure that seens...
August 3, 2002 at 10:46 pm
What are you using to do the import? Perhaps the problem is there and not with the table? The reason I say this is because it says there is an...
August 3, 2002 at 5:04 pm
If you are looking for the # of rows affected by a single SQL statement, there is @@ROWCOUNT. For instance:
DECLARE @Rows int
August 3, 2002 at 4:59 pm
VarChar and VarWChar are variable length character strings. There needs to be something to mark the end of the string. Character 0x00 (or 0x0000 in Unicode), which means null, and...
August 3, 2002 at 8:36 am
What is the processor utilization and pages/sec? Perhaps it's just a case of the system being very slow due to the reindex. How long are you waiting for the reindex...
August 2, 2002 at 4:06 pm
In the second INSERT statement, SQL Server will do an implicit conversion for you. Generally there aren't any issues with allowing SQL Server to do the conversion. However, if you...
August 2, 2002 at 4:00 pm
Viewing 15 posts - 5,221 through 5,235 (of 6,105 total)