Viewing 15 posts - 2,356 through 2,370 (of 2,476 total)
Tempdb is re-created every time SQL is started. If you stop SQL, delete the tempdb files, and restart SQL this might cure your problem. You do not need to keep...
December 23, 2004 at 3:33 am
You could easily implement your SP as a view, by joining your two selects into a single statement.
This would make it easier to join the results from this process with...
December 23, 2004 at 2:58 am
There is not an easy answer to this question. You should consider the application and data retention issues in addition to 'pure' SQL Server issues before making a decision. The...
December 17, 2004 at 10:23 am
SQL2005 IS should be able to pull data from any ODBC compliant data source.
If you can find an ADABAS ODBC driver for Windows, then IS can get your data. (ADABAS should...
December 15, 2004 at 10:20 am
One potential problem of option B is that that Crystal may produce sub-optimal SQL to access the database.
This is a generalisation, but most high-end reporting tools have logic to decide...
November 5, 2004 at 4:16 am
We have used the script below to pull off permissions for database roles:
-- Build statements to replicate authorities for a Database Role
SELECT
CASE p.protecttype
WHEN 205 THEN
CASE
...
November 4, 2004 at 3:11 am
I have not applied this fix, but looking at the hotfix components there are definitely server-based components.
SQL hotfixes are always cumulative, and this hotfix will update your server to level...
November 2, 2004 at 4:21 am
Don't forget that your calculations will just give you the distance as the crow flies, not the surface travel distance. The two can be significantly different where a river estuary...
November 1, 2004 at 6:28 am
There are some problems with dynamic disks that can hit any machine, not just SQL Server ones. The problems appear to stem from the (Windows) database that holds details about...
October 29, 2004 at 3:32 am
I once detached tempdb to see what happens, and how to get things working again. As far as I can remember, this is what I did...
1) Start SQL with the...
October 22, 2004 at 7:17 am
I would go with the approach of C70070540 (Are you related to R2D2?), with a few tweaks.
First build the new server with a different name, connect it to the SAN, and...
October 21, 2004 at 3:28 am
The advice I have heard from SQL Server MVPs who have been involved with SQL2005 DTS since alpha-test days is that it is best to re-engineer your DTS, and not...
October 11, 2004 at 6:39 am
It is quite easy to save a database diagram as a .pdf document.
This is done by printing the document to a virtual printer that outputs the results as a...
October 11, 2004 at 6:31 am
It sounds like what you want to do is to have a template of security permissions that will be automatically applied to an object when it is created.
This is...
October 4, 2004 at 4:27 am
Lots of things are not supported or stop working when running in Fiber mode. A KB search for "Fiber mode" shows some of the issues.
My suggestion is to turn off Fiber mode...
September 30, 2004 at 6:09 am
Viewing 15 posts - 2,356 through 2,370 (of 2,476 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy