Search results for query: *

Thanks a million.

I would like to know if it is possible to remove or delete user accounts from the PUBLIC Role. As far as I know all users will be assigned to Public Role.

I thought so. Thanks for the conformation!

I would like to known if it is possible to "attach" the .MDF and .LDF of a SQL2000 database to a SQL7 database. We want to do certain process on a SQL2000 database. After we took the database off-line, we want to take these .LDF and .MDF to a SQL7 database and use them with SQL7 server. I...

Please, I need Help!! Lately we are getting a Communication Link Failure with certain Applications that are connecting to our Databases. I feel the message cannot tell you exactly where/what the problems are. We checked the SQL Server and everything looks fine. I'm the DBA and needs to give...

The wizard creats the database structures, loginId, etc. Up to here everything seems fine. On the Export Import step I am getting the following error : Error return from function CreateFile in file CnvPipe.cpp Line=143 rc=5 Msg=Access is denied. This process uses named pipes and I assume...

Hi, Is there a limitation on the size of a MSDE SQL database? I think there is a limitation of about 4 GB per database, but I'm not sure. Please Help Thanks

Is it possible to make a SQL backup straight to a mapped drive? All drives I can see if physical drives. Please help

Hi, We have to implement a backup procedure for a fairly big (50GB) SQL database and we come up with the following. Note, data is critical for the business: Full Backup - Sunday night. Differential Backup - Every evening, except Sunday night. Transaction Log Backups - Hourly, except during a...

What is the correct order to schedule a database maintenance plan? I want to include the following option: Optimization, Integrity and Complete Backup. What will happen if the one process overlaps with next of previous process? I assume the SQL Agent will take care of it. I would like to...

We want to know what the impact of NULL values is on physical space sizes on the disk. Is there any documentation to prove when you got an INT value and you store a NULL value in there that it will still take up 4 bytes.

Thanks for the replay karluk. I have stop and start the sql on the server. No luck! I have reboot the server. No luck! Thanks for the reference to the problem. I will look there.

I'm getting the following error on my Enterpise Manager: "An Unexpected error happened during this operaion." All I want to to is to OPEN TABLE and then RETURN ALL ROWS from a table via Enterprise Manager. I will get this message when I want to open any table, even from different...

Is it necessary to install service packs on a pc with only Client-Components installed? On SQL 7 and/or SQL 2000. It makes sense on Server-Side, but what about Client-Side?

I'm new as a DBA for a big company. I must do an audit to see how many SQL servers are there in the company. I know about the facility where you register new SQL servers to click on a button and you will get all the active SQL servers. But this option does not give you a list of all servers...

Can anybody please help me with the following. I'm new as a SQL dba and on one of our servers I'm getting the following in my SQL logs. It happens about every 10 to 15 seconds. DBCC TRACEON 208, server process ID (SPID) 166. What does TraceOn 208 means? If the trace is switched on, are you...