Server Configuration

Triggers after Insert
Hi, I'm having a temporary table in SQL Server 2005, which receives the data from external Orace DB. The data from Oracle DB inserts the data once in a month time. How to create a trigger which calls the storedprocedures, after all the data is get inserted to the temporary table, not for each row insertion. ... 12 Jun 2010 10:27

Can I backup my scripts?
Hi All, I had a third party install some backup scrips for me. He stated: There is no file to put in the c:\ntutil folder as the script code is simply put in a SQL job under the SQL Server Agent. Is there a way I an make a backup copy of these scrips? Many thanks, -T ... 13 Jun 2010 22:42

Script-Out Full Text Search?
Using only the MSSQL 2008 SSMS GUI, I added a full-text index for a single column along with a scedhule. I would like to capture this to a single .tsql script so I can deploy it to other servers ub the farm. How can I captuire "everything"? Thanks. ... 11 Jun 2010 14:49

Help with counting values that have different endings
Hi guys, i just joined SQLMONSTER and was wondering if you guys can help me with this problem... I have 10 columns and 8,000,000 rows which have stock ticker names and exchange tickers-like the following: [Column A] AQR.L GDY.LS NBAE.LS (blank) 0023CA.S FOR.L AQR.KZ ... ... How do I find the number of u... 11 Jun 2010 19:17

count unique nodes
Hi, I have a table that looks like this: Aside1 Aside2 Aside3 Aside4 Aside5 Aside6 Aside7 S0009 S1416 S0009 S5205 S5217 S0009 S5205 S0009 S5552 SWITCH-ASD S0009 S0004 S0010 S1306 SWITCH-ASD S0009 S0004 S0010 SWITCH-ASD S0009 S0004 S0077 S3139 SWITCH-ASD S0009 S0004 S0077 S3526 ... 14 Jun 2010 11:47

Cannot find a particular record by searching on non-primary key
I am a novice in sql. I have a sql2000 running on win2000. I have a table (tblCustomer) with a single primary key (CustomerID) and other fields including Surname and Forename. For one particular record query select * from tblCustomer where Surname='Blogg' and Forename='Joe' does not return any results but query ... 12 Jun 2010 07:11

Upgrade from SQL Server 2005 to 2008 r2
Hi, I'm a novice DBA looking after a DB, there are about 100 users in 3 offices. I'm thinking to upgrade to sql 2008 release 2 from sql 2005. Anyone gone through the process? did you have any notable issues? Should I do any specific 2008 R2 training before I upgrade? Do you recommend any books? thanks in ... 16 Jun 2010 14:23

Another Date conversion problem
I have a query like ............. ............ col11 = 'THIS' OR col12 = 'THAT' AND col13 = '201003' AND col14 = 'THE OTHER' .............. .............. col 13 is a char (6) NOT NULL column with dates that have only year and month in it with also some space. Around 765,000 rows have date and 668 rows ... 14 Jun 2010 09:33

time out
Hi, I noticed when deleting files in OS level(not related to database) caused application level data connection "time out". Is it related or I have IO problem? Please advice. Thanks. ... 10 Jun 2010 19:04

Database Queries with database views, that base on many database t
I created 2 database views. Each of them uses 256 database tables. From every database table only one column is used in the select list of the view. Every database table has one column which is used for the join. Each database table has 5 rows. The database tables have not any foreign keys and indexes. Both vi... 11 Jun 2010 09:14