Viewing 15 posts - 5,056 through 5,070 (of 6,105 total)
BORK = Back Office Resource Kit. The SQL Load Tool came on a CD with BORK 4.5. Database Hammer is a VB app that can be customized with the...
August 29, 2002 at 7:15 am
TempDB is rebuilt each time SQL Server is started. As a result, it's going to use the collation of the server.
You can alter the collation of the server by using...
August 28, 2002 at 11:25 pm
Outlook will need to be on the system.
Log on as the user account you've used for a particular service. Create a new profile which connects to your mail server. Test...
August 28, 2002 at 11:17 pm
When I'm working on some of my own projects I typically script them using EM or QA so I can look them over before moving them. Since we maintain scripts...
August 28, 2002 at 11:06 pm
ADO (or any operation for that matter) with a million rows at a time is going to hurt, even with a relatively small row size. Are tools like DTS an...
August 28, 2002 at 5:12 pm
If I'm not using QA, I'll use TextPad. It's Shareware, and there are downloadable color schemes for commands. Also, you can create commands with keyboard shortcuts to execute an isql...
August 28, 2002 at 5:09 pm
It is odd that the .NET application is forcing a recompile when QA does not. With the execption of the OPTION() where you've already specified KEEPFIXED PLAN, there isn't much...
August 28, 2002 at 5:01 pm
As Antares pointed out, if you can fire up Profiler to catch the query throwing the exception, that would be a big help. There are quite a few articles in...
August 28, 2002 at 4:58 pm
I can as well. If there isn't a relevant KB article, though, I'll warn you that in most cases the user community will point you back to Microsoft to open...
August 28, 2002 at 4:50 pm
Two things come to mind that you're going to need to find out:
(1) You're going to need to know the content type which will match GhostView. Another place to ask...
August 28, 2002 at 4:48 pm
You don't want to stored procedure to recompile unless it's necessary, which in most cases it is not. You might turn on Profiler and monitor the the various Stored Procedure...
August 28, 2002 at 4:39 pm
Create the table based on the recordset that will be returned from the stored procedure. Then use the INSERT statement. For instance:
INSERT INTO MyTable
(Col1, Col2, Col3,...
August 28, 2002 at 1:34 pm
After the beginner articles if you want to continue to expand your DTS skills, you may want to then look at the DTS book Brian Knight is a co-author on:...
August 28, 2002 at 11:09 am
It's the most popular of the SQL Server performance books for SQL Server on Amazon. It's currently running #11 of all books with a search of "sql server" so it's...
August 28, 2002 at 9:40 am
It sounds like someone took the time to drop these extended stored procedures, probably for security reasons. To re-add them, use the system stored procedure sp_addextendedproc. You'll need to know...
August 28, 2002 at 7:47 am
Viewing 15 posts - 5,056 through 5,070 (of 6,105 total)