Recent content by ThomH

We have restarted the SQL Server twice, but can't keep doing this every ohter day, and need to know why it is continually growing so big. Thank you

All of a sudden, the tempd.mdf is growing to 17 gig, Restarted the server, and shrank. This week same thing. Why would this happen all of a sudden, and what is the best way to keep this under contol? SQL2000

Crystal reports are stored in folders, with a file name, that the users click on to run the report. Within Crystal, Titles were created, also with comments. When the reports are published, in Crystal Report Server, they are dispayed with the Title, and can reference the comment as description...

Setting up a maintenance plan in SQL 2005, I do not see the same option that was in SQL 2000, to indicate the amount of days to keep the backup. Backing up once a day, and there just accumulating. How can I change the maintenance plane to delete backups older than 3 days?

Installing the SQL client on a workstation, I am getting the following error: Microsoft SQL Install Setup Installation of the Microsoft Data Access Components Package Failed. How can I get this installed? Thank you!

I have install SQL 2005, on my laptop, but it did not install the Management Studio. I also installed SQL 2005 on a cients server, and installing the client on a workstation, it is not installing the Management Studio. Not sure why?

Can we use a compatability level of 80 in SQL 2005? If so, or there any ramifications we should be aware of?

YES

I tried this, but did not work. The tempdb properties are set to 42,960 under the Space allocation, and I can't change that.

Someone increased the database size of the tempdb to 42 gig. The file is now 42 gig. This is the mdf. How to we reduce, or create a new one!

Is there a way to put a shortcut to a SQL script on the desktop?

Does not work in Safe Mode, or with another user login. Event Errors are as follows: Under Application: ID 15 Source: AutoEnrollent ID 1054 Source: Userenv Under System: ID 7001 Source: Service Control Manager - also ID 7022, and ID 7023 ID 29 Source: W32Time also warning - ID 14 ID 5719...

When starting XP, the menu, tool bar at the bottom does not come up, only the hour glass. Looking at the event manager, there are two errors that may be causing the problem, but Microsoft has no help on them. /LM/SMTPSVC/ Can not be open. /LM/W3SCV/ Can not be open. Any help would be appreciated.

Thank you. Tried this, but process got hung up and would not complete. Any hints on the best way to accomplish this would be greatly appreciated.

Were converting a large Access database to SQL. There are over 100 tables and queries. Were trying to find a faster way to update the data from Access to SQL, instead of appending each table as we are doing now, which takes a long time. Thank you