How best to find out who did what when
I'm trying to satisfy the boss who wants the ability to find out "who did what when" on our DBs. Essentially this request is calling for 24x7 monitoring. Any advice out there please? Should I profile (and if so what events etc) or poll sysprocesses in an indefinite loop? Are there any other options? Thanks from ... 14 May 2010 22:41
Default datetime format
Hi. I want to set gatdate() as a default to a column of datatype datetime in sql server 2000 but in format DD/MM/YYYY. I have used (RIGHT('0' + RTRIM(DAY(GETDATE())), 2) + '/' + RIGHT('0' + RTRIM(MONTH(GETDATE())), 2) + '/' + RTRIM(YEAR(GETDATE()))) but this is not working properly. Regards, Muhammad B... 13 May 2010 12:43
SQL Server 2008 - user wants to directly backup database to his desktop
What is the 'proper' way to allow a user to backup/dump a SQL database directly to his desktop? Thanks ... 13 May 2010 18:18
Code versus Int
Hi, Web applications often use a parameter to select a specific record. Hotmail, for example, uses a code like "ZIaXbPiFjyPUfJG44nag9A%3d%3d" to retriev a specific mail message. Question 1) Is an Int type not prefered? Question 2) What is a smart way to generate unique random numbers? Date + number??? 0... 16 May 2010 15:44
sp_releaseapplock timeout expired?
I've been using a combination of sp_getapplock and sp_releaseapplock for some custom application locking purposes for years now with success and just the last few days I've started to get some timeout expired errors on a sp_releaseapplock which is a bit puzzling. When listing the current locks, there's less th... 13 May 2010 09:23
Pass table name to stored procedure?
Hi, I'm working on a stored procedure that will allow us to monitor some high level numbers we need to keep track of. The challenge here is that this stored procedure needs to be able to run it's code on one of many tables in one of many databases in one of many database environments. The code to obtain the ... 12 May 2010 18:07
Can we access SQL Server 2008 R2 Database Engine with other Management Studio ?
Although I haven't tried it yet I am pretty sure it is possible but not all features will be supported. Did you get an error? If so what was the error? -- Andrew J. Kelly SQL MVP Solid Quality Mentors "Patrick" <Patrick(a)discussions.microsoft.com> wrote in message news:OX#pzEb8KHA.3880(a)TK2MSFTNGP04.phx.... 14 May 2010 04:06
Select TOP on SQL 2005 slower than select full
Hello, ¿Why narrowing results over 63 rows with top is far slower than a full select? My problem can be synthesized in 3 querys. This select runs in 29s: SELECT TOP 63 * FROM HPHPCREL where ( CPNY_COD = 'ATL') ORDER BY CPNY_COD,PERS_COD,END_DAT DESC The same select without TOP runs in 8s (retur... 14 May 2010 05:11
Can we access SQL Server 2008 R2 Database Engine with other ManagementStudio ?
I just install SQL Server 2008 R2 Database and try to access from other machine with SQL Server 2005 / SQL Server 2008 Management Studio but not successful. I would like to know whether it is possible to access SQL Server 2008 R2 database via previous release client ? I have started SQL Browser and enabled ... 13 May 2010 18:18
Alternative to Ms sql server 2005 express edition
Hello Everyone, Our server hosting providers are saying that our web site is running slow because we are using ms sql server 2005 express edition which is a free edition and had only a capacity of handling up to 4 GB data. And our database which we are currently using is now having more than 4.5 GB. Hence th... 13 May 2010 02:54