Search results for query: *

How can I find the defination for a spreadsheet function? Thanks

We have a database that increase the size continuously, the database is updated every early morning by batch updating SQL, then keeps still in the day time. The only scheduled maintenance job is shrink the database to 50M free space, and the SQL Server is always running and never supposed to be...

I want automate the recovery test for our databases, I have a test server which is for all the SQL servers in our company, I can write code to run the restore command with backup files in correct sequence for each database, the problem is I don't know how to write the verification code, I need...

I run dbcc checkdb on one of SQL Servers from my work station, it takes a while then give me an error like network error, the connection broken. I ran it again in the same time I monitor the server using performance monitor, the disk time jumps fairly high when dbcc checkdb is executing, I'm...

I took the SQL server DBA responsibility in our company, I have more than 10 SQL servers or even more to administer in the future, how can I administer them centrally? use EM? Any tips for centrally administering many SQL server instances? Thanks

I looked one of our SQL server database in enterprise Manager, open the database properties dialogue, the OK button is disabled, I have the sysadmin role of the SQL Server, how can this happen? thanks

Has anybody ever used the third party backup tool NetBackup? Does it affect the SQL server backup jobs? Thanks

Using robocopy I can only remove the backup files to a directory and then delete it, is it possible to do this in one step that delete the older files and don't move it? That may save some I/O on the machine. Thanks

Who knows this command? I try to write something that can use the inforamtion from error log, I guess I can use this command. Thanks

I want check the what permissions a user have on a table, I can see he has SELECT permission on the table, but how do I know if he has permission to grant the SELECT to other users?

So many resources and articles talking about SQL Server security, also the microsoft training books. They all fail to give me a clear and manageable strategy to setup a security SQL Server database, many concepts are fuzzy and never be clarified for me. For example, the setup program will set...

1. The sysadmin add a user A and grant him the DBO role to database B. 2. user A create a table C in database B 3. The sysadmin revoke the DBO from user A on database B and leave the public role for him 4. user A still have the full control of table C, so he can update the table or...

I read a article that explains how to secure a SQL Server database, it says that hackers could control the SQL Server service, so if the account that run the service has sysadmin server role, the hacker could do harm to the operation system, base on that, the author of this article suggests...

When I create a login user in SQL server EM, do I need to grant this login user a fixed server role? Is this step neccessary? why? It seems if I don't grant him any role and grant him a database access, he still can access the database.

In maintenance plan wizard, if you choose check database integrity and repair minor errors, the wizard will create a job for it, the command will be : dbcc checkdb(<db>, REPAIR_FAST) WITH NO_INFOMSGS Run this command need to be in single user mode. So this job will always fail. It seems...

If use SQl server as the data sotore. How many per device licenses are needed for a server farm? It looks like depending on the number of the citrix servers. Because each citrix server need to talk with the SQL Server to make sure the static information is update, so communicating between the...

How to protect xp_cmdshell from being executed by a user, say the user running the SQL Server serive.

I try to kill a process, but I can't make it disappear from current activities view. How can I kill a process completely?

I know the best is windows authentication mode, so I thought we might need choose windows auth for any newly installed SQL Server, and still stick to mixed mode for all the existing SQL Servers because the change may involves applicaiton code change, also there are some SQL Server 7.0 is in use...

I know oracle has metalink website for download software, patches, and installation guide, also the Technical Assistance Request (TAR) for all DBAs. Does SQL Server have the similar web site?