Using MS SQL Server

Inserting nulls in to table conflicting with rule
Hi, I basically have two tables with the same structure. One is an archive of the other (backup). I want to essentially insert the data in to the other. I use: INSERT INTO table ( column, column .... ) SELECT * FROM table2 Now, table2 has a rule on various columns: @CHARACTER IN ('Y','N') but the c... 17 Jan 2007 00:21

Why is a simple WHERE clause so slow?
Dear Experts, I have a fairly simple query in which adding a where clause slows things down by at least a factor of 100. The following is the slow version of the query ------------------------- SELECT * FROM ( Select x.event_date From x FULL OUTER JOIN y ON x.event_date = y.event_date ) innerQ WHERE ( in... 15 Jan 2007 01:37

URGENT : SQL Return Code: -25001
Can anyone help me with below error code i am in getting while running a C program using sqls. Password: password SQL Return Code: -25001 BATCH_LOG_PATH: Thank you, D ... 10 Jan 2007 18:41

Connection from ASP page to SQL Server Express
Hi! I have two servers, the web (with IIS - win2003) and the test data server (winXPpro with SQL Express) I'm trying to connect to the db but with no success... here is the connection string I'm using: sConn = "Driver=SQLNCLI; Server=marco-server\SQLEXPRESS; Database=grimp; Uid=grimpuser; Pwd=somePasswor... 8 Jan 2007 18:06

ssis issue
I am trying to create a job in ssis for a package I created. I able to execute the package, but get the following error when I run the job [298] SQLServer Error: 22046, Encryption error using CryptProtectData. [SQLSTATE 42000] Anybody have any idea how to get around this? ... 3 Jan 2007 03:56

Capture CPU Utilization in TSQL
Happy New Year everyone! I would like to capture CPU Utilization % using TSQL. I know this can be done using PerfMon but I would like to run TSQL command (maybe once every 5 minutes) and see what is the CPU Utilization at that instant so that I can insert the value in a table and run reports based on the data. ... 3 Jan 2007 12:31

Changing a BIT to an INT where there's a CONSTRAINT and a DEFAULT
A few weeks ago a client asked me to add a column to a table so I created this script: ALTER TABLE dbo.tblIndividual ADD fldRenewalStatus BIT NOT NULL CONSTRAINT fldRenewalStatus_Default DEFAULT 0 Now they want to change it from a BIT to an INT, to store an enum. Fair enough. However, no matter how much I wra... 3 Jan 2007 03:56

Convert from Access to SQL Server
Can I convert .MDB file to SQL Server database or I need to develop SQL server database from begin, every table, every field? ... 28 Dec 2006 08:53

Selecting last date
Hello, I have a couple of tables. The client tables and the contacted tables. I am not sure how to start on this, what I need is a way to query all my clients then show any client that the last visit and or called day is greater than 30 days. Now it gets confusing, Suppose the client was visited more than ... 3 Jan 2007 11:28

pagefile and memory advice??
Hello, I've been reading about this topic, and I've gotten myself more confused, not less. We have a single-processor license SQL Server Standard 2005 (xeon 2.8 ghz) with 4 GB RAM in Windows Server 2003 SP1 Standard. I turned on the /3GB switch in boot.ini but not PAE or AWE, would it be good to have either on... 20 Dec 2006 18:57