Hi I'm migrating data from the old schema to the new schema using DTS. The old and new schema are different. In the new schema we have identity columns as Primary keys and referred as foreign keys in the child tables. In the old schema Primary keys are not identity columns. So when I migrate ...more >>

Under whose permissions does a trigger execute? Under the permissions of its creator? Or under the permissions of the current user? Thanks TR ...more >>

I am creating a cursor, and then scrolling through it, dumping the data into a temp table. It seems like the first row is getting duplicated in the temp table. If I run the query used to fill the cursor on it's own the data is correct, so I am pretty sure it's how I am putting data into the curso...more >>

Thank you for your help. What am I missing here? I read the BOL. I just dont see what is the problem. SET ANSI_PADDING ON GO SET ANSI_PADDING ON GO if not exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[OrderLineSAItems]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)...more >>

/* Thanks in advance for your time and knowledge you would share. Definition: I have actions, that are of certain type, and workload of these actions to process The request comes as a recordset in request table. How do I produce a record set that has in it quantity of records less or equa...more >>

I have a teacher-student-grade model and I'm trying to find a query that will show me the duplicates Here's a simple representation of my shema create table student (studentid int primary key, studentname varchar(50)) create table teacher (teacherid int primary key, teachername varchar(50)) ...more >>

Hi, I have a datetime field SDate with a value '1/1/02'. I want to display it as 01/01/2002 in a view. So I use this statement: SELECT CONVERT(datetime, SDate,101) from Table1. But it still display it as 1/1/02. The Help says 101 will display yyyy if I use it with CONVERT. Thanks....more >>

Hi, I have a datetime field with a value '1/1/02'. EM display it as 1/1/02 But Query Analyzer displays it as 2002-01-01 00:00:00.000 (I used SELECT * FROM Table1) So in Query Analyzer, I can't tell the fomat of it. I just wonder if your PC does the same. Thanks. ...more >>

Hi, With EM is open, I use Query Analyser to create a table in Pubs. After I refresh EM many times, it does not display it. I have to close EM and reopen it to see the table. When I closes it, EM asks me if I want to save this new table. Is this normal? Thanks. ...more >>

I have an asp news letter page that grabs a text article from a SQL Database field that is varchar 8000 type. When I retrieve the text from that field using an ADO Recordset to display on a page, the text is fine. If I use a SPROC to retrieve the news story, the text gets chopped off after...more >>

I want to call a script/sproc at the beginning of a nightly ETL process that will drop all indexes in a user-defined database. At the end of the ETL process I will call a stored procedure (I already have) to recreate the indexes. ...more >>

Hello, I want to use a subquery within my main query but only dependant on a parameter's value. I can do this with dynamic SQL but want to try to avoid this Here is mySQL without the parameter SELECT Id FROM tblAccounts a WHERE EXISTS (SELECT NULL FROM tblSales s WHERE a.Id = s.Acco...more >>

Hi, I have a question about recursive trigger. Suppose there's a table A which has 1 insert trigger and 1 update trigger. The insert trigger updates table A. My question is will the update trigger be fired by the insert trigger?...more >>

Hi, can I get the SQL service memory usage? and which one holding lots of memory? ...more >>

I'm trying to create a function that will help with maintaining data consistency. The goal is to 'test' for partially matching values that are contained within one of two tables, and then to 'apply' the appropriate (i.e. 'valid') value. tblMakes, MakeName varchar(255) -- currently holds 56 rec...more >>

Hi, I want use next schema to pump large amount data to MsSql database, if happend some excepton must all cancel via Rollback CDatabase dbMyBase; dbMyBase.OpenEx(strConnect, CDatabase::noOdbcDialog | CDatabase::useCursorLib); try { while ( /*here is some expression*/) { dbMyBase.Ex...more >>

I find that many stored procedures are necessary in nearly all databases I use. Creating dynamic (one that takes a string and executes the sql in it) stored procedures is expensive performance wise. However, they do allow you to pass in strings of sql and execute it. I find in general that S...more >>