|
Impersonation Question Impersonation question I need to have a user (DOMAIN\USERA) connect to server01 using their own rights they already have by virtue of whatever Active Directory group they are in, then I want them to impersonate USERB. USERB has rights to run sp_start_job on SERVER02. Then they need to start a SQL Server Agent ... 13 Aug 2010 17:58
SQL Server Service User Account Is there a reason why an account, having administrative privileges to the local machine, other than localsystem, should not be used to run various sql services? Thanks in advance ... 13 Aug 2010 16:52
What does red cross icon mean beside server name in SSMS in sq the servive is started, I can use it. But still have red cross icon in my SSMS. "Amol Lembhe" wrote: Can you make sure that SQL Service is started for that instance? "Iter" wrote: I am using sql server 2008. I just notice there is red cross icon beside server name in SSMS. Can anyone te... 13 Aug 2010 13:36
SQL 2005 SSAS license Hi. Is SSAS a part of SQL server 2005 license or we need to purchase it separately? Thanks, ... 13 Aug 2010 12:30
How to delete .txt files from \Program+Files\Microsoft+SQL+Ser May be you can add first step in existing job for deleting old .txt files using xp -cmdshell "hayko98" wrote: On Aug 12, 10:06 am, hayko98 <vardan.hakop...(a)gmail.com> wrote: Hi All, We have SQL 2005 and would like to automate deletion of .txt files from \Program Files\Microsoft SQL Server\MSSQ... 13 Aug 2010 15:47
What does red cross icon mean beside server name in SSMS in sql 20 I am using sql server 2008. I just notice there is red cross icon beside server name in SSMS. Can anyone tell me what it means? Thanks ... 13 Aug 2010 02:46
@@VERSION Gives Different Info Than Enterprise Manager (SQL 2000) Hello, We have a server running SQL Server 2000 running on Windows Server 2003 R2. When I run "select @@version" in Query Analyzer, I get the following output: Microsoft SQL Server 2000 - 8.00.2055 (Intel X86) Dec 16 2008 19:46:53 Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Window... 12 Aug 2010 18:06
File/Filegroup last changed Is there any way to tell when the last time data in a file or filegroup has changed? ... 13 Aug 2010 03:50
How to delete .txt files from \Program+Files\Microsoft+SQL+Server\MSSQL.1\MSSQL\LOG Hi All, We have SQL 2005 and would like to automate deletion of .txt files from \Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG folder. We have Maintenance plan running which creates .txt files. Any suggestions/ideas? Thanks IA ... 12 Aug 2010 15:54
Database-Level Roles documentation in BOL rgn (rgn(a)discussions.microsoft.com) writes: Looks like there is a typo that I noticed while preparing a SOX document. The Sub section says "Working with server-level roles" but it should be "Working with Database-level roles", correct. The same with "The following table explains the commands, views and... 12 Aug 2010 10:23
Stats assessment, accurate? -In SQL2005, it is OK to have older stats provided the table has not changed. How old is really older for optimizer or it doesn't care as long as table table has not changed? -Auto updates stats will update table stats only if the table data has changed more than 20%. -If the database auto stats update is on. It ... 11 Aug 2010 18:04
Ceckpoints in SQL 2005 Does sql server maintain a view containing info on checkpoint activity? Like when the checkpoints took place and how long they ran. Thanks in advance ... 13 Aug 2010 19:04
Remove Duplicate Rows Hi, PFB a simpler way to delete Duplicate data from a table USE SAMPLE GO CREATE TABLE #TAB1 (ID INT, NAME VARCHAR(10) ) INSERT INTO #TAB1 SELECT 1, 'JOHN' INSERT INTO #TAB1 SELECT 1, 'JOHN' INSERT INTO #TAB1 SELECT 2, 'Stephen' INSERT INTO #TAB1 SELECT 3, 'Sonia' INSERT INTO #TAB1 SE... 11 Aug 2010 14:45
What does Profiler/Perf Monitor tick marks represent? Hi all! I am correlating my SQL profiler trace file with Perf Monitor csv data. When I import the performance data, I see the left side of the line graph is numbered from 1 - 100. The graph looks great but I do not know what the 1 - 100 represents for my data. Do you know what these tick marks represent? Thank... 11 Aug 2010 14:45
SQL_Latin1_General_CP1_CI_AS and Latin1_General_CI_AS Hi, We have a large number of SQL 2000 databases having collation SQL_Latin1_General_CP1_CI_AS. We are now upgrading to SQL2008R2. I know that the default collation for 2008R2 British English is Latin1_General_CI_AS. One of our clients has indicated a preference for installing their new server with a default c... 11 Aug 2010 18:04
Database-Level Roles documentation in BOL All, Looks like there is a typo that I noticed while preparing a SOX document. The Sub section says "Working with server-level roles" but it should be "Working with Database-level roles", correct. The same with "The following table explains the commands, views and functions for working with server-level rol... 11 Aug 2010 11:28
Changing database collation for existing databases Hi, We are upgrading from SQL2000 to SQL2008R2. We are taking the opportunity to update the collation on our databases. Sorry to bring this up again but there are a lot of partial answers online and a lot of conflicting information. Our situation is that we have a database with NO COLLATE clauses, i.e. all col... 11 Aug 2010 18:04
Large Log File Hello, i have a replicated database (3 GB) with a log file that grown to 38 GB. The recovery Model is simple. DBCC Shrinkfile doesnt works. DBCC OPENTRAN say: Replizierte Transaktionsinformationen: Oldest distributed : (0:0:0) Oldest non-distributed LSN : (297400:25:1) What can i do, t... 11 Aug 2010 06:01
Large log file Hello, i have a replicated database (3 GB) with a log file that grown to 38 GB. The recovery Model is simple. DBCC Shrinkfile doesnt works. DBCC OPENTRAN say: Replizierte Transaktionsinformationen: Oldest distributed : (0:0:0) Oldest non-distributed LSN : (297400:25:1) Rich L... 12 Aug 2010 09:17 |