Search results for query: *

OK Thanks for your help.

I've always seem to notice that when SQL takes what it needs when it needs to, it never "lets go" when it's finished. sqlsvr.exe always starts out low after a server re-boot; then over time it takes more and more (gradually keeps growing and growing). Why is that?

Thank you mrdenny. If I look at the memory tab under the SQL server properties, I see that it is currently set at the defaults; 1) Dynamically configure SQL server memory is selected (dynamically adjust) and 2) minimum query memory is set at the default of 1024KB So if I upgrade the ram on the...

Hello, Our company has a Dell 2600 Poweredge data server. It is running an instance of SQL server 2000, Standard edition using Windows 2003 server standard edition OS. The server currently has 2GB of ram. It is running one production database app, accessed by several end users. We're...

Got it. Thanks.

Hello, I have a question regarding Windows Authentication. I have an instance of SQL 2000 server (SP3) running on a server that has Windows 2003 server, standard edition on it. The server is part of the same domain name in our active directory. In the Security tab settings of Enterprise...

So, to place a user database into single user mode, is it just a matter then of conecting to the database using query analyzer and issuing the "alter database db-name set SINGLE_USER" command?

Hello, I am writing to inquire whether anyone has had experience in Crystal Report development work via data access to an IBM RS6000 server. I have done work with an AS400/iseries but the RS6000 is a new one for me. For example, does the connection to this server similar, i.e. an ODBC...

SQLBill, I am merely setting up a maintenance schedule using the feature/wizard inside Enterprise Manager as part of SQL Server 2000. Yes; this is a user database, not a system database.

Hello Mrdenny, My scheduled integrity check and backup did not run because the error reports state that the "Database needs to be in single user mode". According to Microsoft's site, having the "attempt to repair any minor problems" checked can cause this. I did have it checked so I have...

Hello, I have an instance where a background service runs on a SQL 2000 server. It has Windows 2003 server standard edition as the OS. The service is part of an app that polls data from another source and stores that data on the SQL database at selected times through out the day. I have a...

say mrdenny, How do you configure SQL Server to not use all the available memory? I have a case where the server has 2GB of ram in it; sqlsevr.exe is using nearly 1.5GB. The server also has an app on it that will be accessed/queried by several users. - Kevin

Yes, I logged on as myself and I could open the document just fine. So I deleted per profile, she logged onto the PC today, which re-created a new profile, and as soon as she attempted to open the Excel document, the PC re-booted again; yet it opens for me ok under my login. She can log onto a...

Hello, I have a user that has an infrequent issue with Excel 2003. She'll browse to a folder on the network, browse to the Excel file, and double click on it. Upon doing this, her PC immediately re-boots without any error messages. It appears to happen on selected Excel files that have images...

Thanks Bill, I did this task over the holiday break and it worked fine. One other question though; If I look at the database in enterprise manager using the taskpad view, it shows that the database is 126MB in size, with 125.69 used and .31MB free. If I look at the database properties, it is...

One other question for you SQLBill, You write about making sure that I set the owner to the correct owner; how/where is this done?

SQLBill, This would be a User database that was set up from a vendor application program that runs as a client/server app.

Hello, I have a task at my new job where I need to move an SQL 2000 database from one volume on the server (running Windows 2003 server, standard edition) to another. The vendor that originally created the database (before I started here at this job) set the database up on the c volume which...

That's it!! That worked! Thanks so much.

Hi there lbass, It is a datetime datatype.