Search results for query: *

I have a SQL Server (2008 R2) with 10 databases. I have to grant a user access to a database using management studio. Is it possible for me to grant the user access to the server but restrict access to the other databases. Truthfully I would like for them to only see the database they need to...

Is there a way to map all users to a particular database? I have a server with multiple users that have there own databases. In addition to there own databases I need to grant them all access to a repository database. Without going through each user login is there a way for me to grant them...

I am having an issue running the sp_send_dbmail from a non sysadmin account. I am running SQL Server 2008 R2 SP1. I gave the user permissions to the DatabaseMailUserRole under the msdb database however anytime I try to run the sp_send_dbmail I get the following error message: Msg 14607, Level...

I am running into an issue that I hope someone can shed some light on. I have a job that backs up the transaction logs every 30 min. When a new database is added the transaction log backup job fails because the new database does not have a corresponding full backup. I was wondering what is the...

Is it possible to determine the database name on the server from a backup file? By this I am not referring to the logical name which can be retrieved from the RESTORE FILELISTONLY command. I am referring to that actual database name as how it was stored on the server. Any help would be...

I have been tasked with trying to move sql server user accounts from a sql server 2000 instance to a sql server 2008 R2 box. I have about 200 databases each with unique user ID's. I know that the security information is stored in the master DB. Is it possible for me to extract the user name...

I am trying to find a good SQL Server Monitoring software. Does any have any recommendations or suggestions? With Great Power Comes Great Responsibility!!! [afro] Michael

Hey guys, I'm hoping someone can help me out with this. I'm building a Citrix Farm hosted at Amazon Web Services. Windows 2008 R2, SQL 2008 R2(SP1). I get through the install and all the way to the end of the config and it fails at Registering Citrix Administrators Specifically: Setting...

When selecting a user account to start an sql server instance what is the best service account to use. Should one of the service accounts be used or should a watered down domain account be used. I know that for 2000 it was recommended to use a domain account. Can some one explain to me the...

I have a server which has multiple databases. Each database has identical stored procedures that create temp tables in tempdb. Each temp table has a unique table name stored in the tempdb..sysobjects table for example: #testtable______________________1234567...

Is it possible to have a clustered primary key store data in desc order? If not would do I just need to not make the column strictly a clusterd index (no primary key) in desc order? Any help is greatly appreciated. With Great Power Comes Great Responsibility!!! [afro] Michael

I am considering taking the SQL Server 2008 certification exams and was wondering if anyone could recommend some good books to prepare for the exams. With Great Power Comes Great Responsibility!!! [afro] Michael

I have a client database that has a rougue user in its sysusers tabe. The use does not exist in the master database or on the server. I have tried the standard methods of removing the user from the database: sp_dropuser sp_droplogin sp_dropalias But none of them work. I even created a dummy...

I am trying to run extract all of the order number values in my XML and for some reason I am only seeing the first order number (0000001) of the 3. Here is the code: DECLARE @pOrderNumberXML VARCHAR(MAX) SELECT @pOrderNumberXML = '<root> <ordernumbers>...

Is there a way for me to tell if a trace is being run on a sql server? With Great Power Comes Great Responsibility!!! [afro] Michael

I never tried this before until now is it possible to use a delete from in a user defined table valed function. I created a memory table in the function and tried to delete from it and found that I could not. I just wanted to know if deletes are not allowed in this manner. Any help would be...

I am not sure if this is possible but I was wondering if you can suppress a result set from a stored procedure. Let me explain. I have 2 stored procedures SP1 and SP2 that both return back record sets. I have modified SP1 so that it calls SP2. When I run the modified version of SP1 it...

My company generates a large amount of internal reports. Right now we are in the process of moving from Crystal Reports to SQL Server 2005 Reporting Services. Not all users should have access to every report. Is there a way to set up in active directory a way for only certain users to have...

Is there a good website with good examples to start learning SSIS? With Great Power Comes Great Responsibility!!! [afro] Michael

We run a lot of reports at my current company and only certain groups have access to certain reports. I was wondering is there a way using reporting services to restrict what group has access to what reports possibly utilizing Active Directory? With Great Power Comes Great Responsibility...