Programming SQL

login via ad groups - query to find this info.
Hi, Is it possible to run a query to find all the ways a user has been granted a login to SQL server. for example a user may have a login because their windows login has been given login righs to sql server, This senario is pretty easy to find. However a user may have login rights because they have been grant... 22 Jul 2008 08:34

IF and TRANSACTION problem
Hi, Have a problem that is probably easy to fix, but I cannot understand why this happens. The following code fails because of the GO's in the code: -------------------------- IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ExtraUserSettings]') AND type in (N'U')) Begin ... 22 Jul 2008 20:55

help on if logic
-snip- if (@TotalInTodayFromSameIp<10) and (@PublisherLastEranedDifferance > 10) and (NOT @PublisherLastInAgent=(a)browser) and (NOT @PublisherLastInIp=(a)ip) and (@selectedid is not null) BEGIN -snip above IF runs query below BEGIN when all matches (obviously) i want to make (NOT @PublisherLastInAgent=(a)brow... 22 Jul 2008 06:31

Script to fix sysdepends
I remember once apon a time I had some code that would fix up the sysdepends table. Basically it would go through every stored proc/view/function etc, get their help text and execute it (with an alter statement). I did this in C# but the code is now the property of my former employer. Before I redo all that har... 24 Jul 2008 18:04

help!!
how to enter data from a website into a database??? ... 22 Jul 2008 09:35

logging column changes
Good day! I would like to know how you went about with your logging problem because I'm having the same problem with my database right now. I want to create a trigger that retrieves the old value and new value of a changed column in a table, so far I could not determine which column changed unless I list down all co... 22 Jul 2008 00:23

Why do I have to be a SysAdmin to use the debugger !?!?!
Why do I have to be a SysAdmin to use the debugger !?!?! Seems like everyone should be able to use it. I'm tired of spending hours putting Print statements in my code. Surely there has to be a better way! ... 23 Jul 2008 19:30

Locks
Hi , I have some quesation about Locks in the sql 2005.In the application I call 50x delete where I delete from table rows with specific range datetime.Why this command locks second delete and not run paralel ? thanx ... 22 Jul 2008 10:37

Need help with a hard SELECT STATEMENT.
Start with something simple. SELECT PortID, AllocQty FROM MoxyAllocation WHERE Omnibus <> 3 UNION SELECT PortID = 8080, SUM(AllocQty) FROM MoxyAllocation WHERE Omnibus = 3; "pvong" <phillip*at*yahoo*dot*com> wrote in message news:eCHiDh36IHA.3816(a)TK2MSFTNGP03.phx.gbl... This is on SQL2005 and I'm... 21 Jul 2008 18:14

"parallel nested xacts outstanding" error reported from my custome
I've had two of my customers report the following error from a SQL stored procedure call in our application, running on SQL Server 2005. BEGIN ERROR A severe error occurred on the current command. The results, if any, should be discarded. Location: "xact.cpp":2630 Expression: !m_updNestedXactCnt SPID... 18 Aug 2008 18:47