Programming SQL

keep alive option for the server or client
I have a client in the DMZ and a server on the internal network. The firewall is killing the connection between them after a period of inactivity. Is there a connection string for the client or a server option that will do "keep-alives" so that there isn't a time of inactivity? dan ... 28 Jul 2008 18:15

set transaction isolation level on production systems
How do people typically configure production systems to set transaction isolation level globally ? "globally" could be instance-level or db-level ... For example, by default I want all transactions on my instance to be read committed snapshot ... ... 28 Jul 2008 20:18

Need help with UPDATE trigger
I have sometable and sometable_old. Whenever a record is updated in sometable, I need to insert that record (as it was before the update) into sometable_old. As an example, sometable has just one field: id sometable_old has two fields: entrynum (identity field), id I have created a trigger on sometable that ... 29 Jul 2008 11:37

Cannot figure out a part of multi joined sql code
Hi, I have a view in sql server database where the sql statement is as follows (multi joined sql) SELECT PR.Project_Num AS ProjectNo, PR.Gen_Level, PR.Customer_ID, PR.User_ID, PR.Project_Name, PR.Project_Desc, PR.Date_Submitted, PR.Date_Due, PR.Date_Estimated, PR.Date_Completed, ... 28 Jul 2008 18:15

Try...Catch... for INSERT...SELECT
I have a Catch block for an Insert...Select statement. This statement may insert zero, one or multiple rows. In my Catch block, is there any way to determine the primary key (Identity column) of the record I attempted to insert when the failure occured? Or, should I even be attempting to do this? Thanks. ... 29 Jul 2008 16:48

Date comparison
Hello All, I amgetting totally confused about this date comparison, can someone see what I am doing wrong and help me I have 2 parameters start date and end date. I have a service date(ser_datestart) and a proactive date(pro_datestart). AllI am trying to do is to get all the service dates and pr... 28 Jul 2008 16:11

SMO: IncludeIfNotExists is ignored when scripting Column.DefaultConstraint
I have the following code in SQL 2005 using the SMO object model: ' Options to script the default constraints. Dim DefaultConstraintsOptions As _ Microsoft.SqlServer.Management.Smo.ScriptingOptions = New _ Microsoft.SqlServer.Management.Smo.ScriptingOptions DefaultConstraintsOptions.IncludeDatabaseContext = Fa... 28 Jul 2008 13:06

Selecting "All" vs "List" in an sp
I have fairly lengthy sp that on some occasions will select data for "All" (CustId's e.g.). Or other occasions there is a variable that represents a concatenated "List" of (CustId's). -- with a function to turn the list to a temp table What is the easiest way to accommodate the option to print all or from the ... 28 Jul 2008 14:08

Transact-sql: Giving more than 1 user access to a particular schema and setting certain access restrictions for each
1. I have the user EternityNews that has their default schema set to News. I don't want this user to have certain abilities like creating tables and dropping them. How do I do this? 2. I have the user EternityRecords which is the DBOWNER. Does this user already have access to everything or do permissions need ... 29 Jul 2008 07:30

Returning top 5 in a join?
Hi, Using SQL 2000. I am trying to join two tables in a query with a one to many relationship. Trouble I'm having is I only want to return the top 5 of the joined table records. What I have is an inventory table and a history table. So for a given list of serial numbers I only want to return the 5 most r... 28 Jul 2008 13:06