Search results for query: *

I am trying to create a stored procedure or SQL Job to run the following command. use Master GRANT ALTER ANY LOGIN TO "domain\login" GO I can run the above command just find manually from a SQL Query but when I try to creat a SQL Job and run the command I get a syntax error? Does anyone...

I am having some issues with securing my SQL Server Reporting Services. I are using SQL Server 2008 R2 and Report Builder 3.0. I are using the Native Mode. In the rsreportserver.config I am using <RSWindowsNTLM/>. The SSRS Service runs as Domain\mssql123. I am the DBA and my login is...

I am having some issues with securing my SQL Server Reporting Services. I are using SQL Server 2008 R2 and Report Builder 3.0. I are using the Native Mode. In the rsreportserver.config I am using <RSWindowsNTLM/>. The SSRS Service runs as Domain\mssql123. I am the DBA and my login is...

I moved from SQL Server 2005 Reporting Services to SQL Server 2008 R2 Reporting Services. Since I Upgraded now everyone has access to do whatever they want in reporting services. In the ReportServer table I see UserName: Everyone, UserType: 1, AuthType: 1 I am not sure how this got there...

I have multiple SQL Servers. On each of the SQL Servers I have Alerts setup. One of them is for Insufficient Permissions. I am using SQL Server 2005 SP3 On some of my SQL Servers if their is a login Failure the alert works just fine. The Notify Operators receive the Email saying Login...

I have 'Netapp SnapManager for SQL Server Management Console' installed on my Server but I have never used it. I do all my database backups using Quest Litespeed. My server Admin wants to uninstall the Netapp SnapManager. Is there any reason I need Netapp SnapManager and it should not be...

I upgraded from SQL Server 2005 SP3 to SQL Server 2008 R2. I am having an issue with our Report Services - My Reports Folder. Users have a 'My Reports' folder but they can not see their reports. I can go to 'Users Folders' and see their folder with the reports in it. If I type in...

Is there a way to uninstall SQL Server but not uninstall the Tools and Components? Do I need to uninstall SQL Server and then re-install the SQL Server Components and Tools?

According to my notes for SQL Server 2005 Set 'Maximum Server Member (In MB)' to 1 GB less then the amount of RAM on the Server. Example: 32 GB – 1 GB = 31 GB * 1024 = 31,744 MB, then round it to the nearest thousand Is this correct? Any other feedback? In our SQL Server Monitoring...

I backed up one of my databases and restored it with a new name. I do this each monthend. I backup database xyz and restore it as YYYY_MM_xyz. This month for some reason the database name has (Restricted User)? The database looks like: 2010_12_xyz (Restricted User) I have never seen a...

I am getting errors on just a few of my shared schedules for SQL Server Reporting Services. I can not figure out why some shared schedules are giving this error and why others are not. All in the properies on SQL Reporting Services Shared Schedule seem the same. All in SQL Server Database...

My Database backup never ends. I was able to previously backup the database in less then a minute. Now my backup runs forever and never ends. It has a wait Type of "MSSEARCH" I stopped the backup. I then Killed the backup (kill spid). The Backup still shows in the Activity Monitor. The...

I need to uninstall SQL Server 2005 and then reinstall the program. Our current SQL Server has many databases I want retain once I have reinstalled SQL Server. I am assuming the uninstall will not delete my database files???? I currently have the SQL Server program and the databases all...

I am trying to delete a user from a database. I am using SQL Server 2005 The user I am trying to delete was the user we used when created the database. Aside of being the owner on the database this database user is no longer needed. I want to change ownership of the database to another user...

I have a SQL Query I run and then export the results to a text file. I need to add a Footer to the text file. Is there some way to add a footer in my SQL Query? Below is my example Query: DECLARE @Startdate datetime DECLARE @Enddate datetime SET @StartDate = GETDATE()-3 SET @EndDate =...

I need help on a view I am trying to create. In my sql code I am using the row_number() function (see code below). The sql works fine as a query but when I try to create a view I get error: The OVER SQL construct or statement is not supported. Please help me re write this sql so I can use...

I need help on a query. I am trying to create a mail list. Below is the query, sometimes there are more then one households living at the same address. if there are multiple headOfHouse at the same address I want only the one with min(HeadofHouse). Select HeadofHouse , FullName =...

I am a DBA on SQL Server 2005 and SQL Server 2000 environment. I am new to Analysis Services, most my DBA experiences is from SQL Server 2000. I run daily Backups on all databases in SQL Servers but I do not run any Backups on Databases in Analysis Server. Should I be running a Daily backup...

How do group on a text file? select ivr_msg, count(ivr_end_date) from dbo.Wings_IVR_CallInformation group by ivr_msg Error Message: The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator. Can I convert ivr_msg to a different type and...

Is there a SQL Query I can run on Master to see all the logins that are in the SYSADMIN Server role? Using SQL 2005