Programming

Thread preview

Thread	Last Post	Replies

Can I create tables directly in TMPDB?	29 Jul 2008 16:06 GMT	7
I have a series of tables that have temporary nature. I need a database with basic recovery model. Can I create the tables in tmpdb? Is that supported? Thank you,
Need help with UPDATE trigger	29 Jul 2008 16:00 GMT	4
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
Attach LDF using CREATE DATABASE ... FOR ATTACH?	29 Jul 2008 14:42 GMT	5
I am trying to create the syntax to attach a database, both the MDF and the LDF files. Is it possible to do this with CREATE DATABASE ... FOR ATTACH or do I need to use sp_attach_db? If so, can someone please provide me the proper syntax? Thank-you, Rubens
Datediff syntax	29 Jul 2008 13:52 GMT	5
Using SQL Server 2005 Given that the column called CURRTS is a date/time field, I'm trying to pull the rows in a table in which the rows were added in the last 30 days. The CURRTS field records the day the row was added.
Nested Transaction	29 Jul 2008 13:27 GMT	4
Is there any use for Nested transaction? If we rollback the transaction in any level everything rollbacks. I guess no use without savepoint. Signature Thanks
Transact-sql: Giving more than 1 user access to a particular schema and setting certain access restrictions for each	29 Jul 2008 12:13 GMT	5
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
Using OUTPUT clause to get data on multiple inserts	29 Jul 2008 08:49 GMT	3
I have 3 related tables, the first table has a primary key (IDENTITY column) which needs to be added as a foreign key in the second two tables. I load all tables with INSERT... SELECT statements I was advised to use the OUTPUT clause to get the identity values for later
number of columns	29 Jul 2008 05:06 GMT	5
is there an easy SELECT statement i can use to figure out the number of columns in each of my tables? Darin
CharIndex and Replace	29 Jul 2008 03:43 GMT	4
I've got a varchar value that represents several values seperated by a dash. Some of the values contain dashes as well which is making it more challenging. An example would be 123,456-333,123-999,877
set transaction isolation level on production systems	29 Jul 2008 01:01 GMT	3
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
keep alive option for the server or client	28 Jul 2008 23:09 GMT	1
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?
Cannot figure out a part of multi joined sql code	28 Jul 2008 23:02 GMT	4
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,
Display contents of table variable?	28 Jul 2008 23:00 GMT	1
Is there any quick and easy way to display the contents of a table variable?
migrate	28 Jul 2008 21:03 GMT	3
How to migrate DTS Packages from SQL 2000 to SSIS in SQL 2005. Please help on this Thanks Raj
Date comparison	28 Jul 2008 20:19 GMT	5
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).