Programming SQL

Who Created a Table
Hello, (my first post to this group so please expect some vagueness!!) I'd like to be able to find out who created certain tables - if it was me then I know I can delete the table. We are using SQL Server 2005. Can't see anything in the table properties - wondering if this info is stored somewhere? Any h... 11 Nov 2008 09:57

The query processor ran out of stack space during query optimization. Please simplify the query.
How can I delete some rows from a database when I get the above error? It is a simple delete from table where column = value type statement. ... 14 Oct 2008 18:15

T-SQL - How to use xp_regread to get ALL time zone information
xp_regread can be used to determine the Time Zone offset from the windows registry. The TZI portion of the example registry key below is of type BINARY. HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Time Zones\AUS Central Standard Time] "Display"="(GMT+09:30) Darwin" "Dlt"="AUS Central ... 4 Oct 2008 02:37

"Timeout expired" when querying linked server
Hi all, I am working with SS 2000 and get the following error when querying linked server: <?MSSQLError HResult="0x80040e31" Source="Microsoft OLE DB Provider for SQL Server" Description="Timeout expired"?> The strange thing is that 1 out fo 5 times runs OK. Remote Connection Timeout on linked server is set to... 30 Sep 2008 23:50

TransactionAbortedException Occurs Randomly
Somewhere around the 50th time the method shown below is called a TransactionAbortedException is thrown. The inner exception is "The requested operation cannot be completed because the connection has been broken". Does anyone know what would cause this to happen? protected void Insert() { using (Transac... 24 Jul 2008 16:00

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

Check Reporting Services Installation Programmitcally
Hi, Does anyone know how to check if Reporting Services is installed through code? Thanks in advance. ... 21 Jul 2008 18:14

DBCC CHECKTABLE error
I'm receiving a 8115 arithmetic overflow error on a DBCC CHECKTABLE. The clustered index is on a datetime column. There are 20 million rows. Version 8.00.2039 - I'm about to patch to 2187. The indexes were rebuilt without error. Dan ... 29 Jul 2008 18:52

Creating parameterized query in SSIS package
Hi All, I have created a query to run in a .dtsx package. I would like to parameterize it so that a user can input a value via the Execute Utility dialog when the .dtsx package is double-clicked. Any info would be appreciated! Thanks, Gloria ... 18 Jul 2008 05:09

back up jobs, re-index question
We have a db that is accessed by users on the web 24/7. Problem is when our maintenace job runs users are getting killed with this error: Database Error: SQL Error #-2147217900 [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction manager has canceled the distributed transaction. (Source: Microsoft OLE DB Pro... 30 Apr 2008 18:00