Hi all, Ok - I'm familiar with the process of deleting rows from a table, however... If I have a series of tables which are linked together by an ID field thus creating a hierarchy (tier 1, tier 2, tier 3, tier 4 etc) - if I then want to remove a row from tier 1 and 'everything' which is lin...more >>

I have two tables shown below. When someone logs into the network the computer registeres it's information in the two tables shown below, hence duplicating it's computername, ipaddress, and username information in each table (don't ask me why the guy setup it up for two tables instead of com...more >>

Hi, I need to do the following through Enterprise Manager (EM). I need to copy the structure of all the tables along with their PK, FK etc and need to copy the data of only select set of tables (not all of them). I tried doing this in EM but lost the relationship between tables in the target ...more >>

Hi, I have my SQL Server running in Texas (-6.00 hrs relative to UTC) and my friend end application runs in UK. So Wherever i use the GETDATE() function, its displaying the US time. I wanna know How can i convert the time to UK other than using DATEADD. regards Aneesh ...more >>

Hi all, I have the following tables: tblPages PageID SectionID tblPageAssociations PageID SectionID tblSections SectionID all columns are of INT type. What I have done is added SectionID to tblPages so that I can drop the use of tblPageAssociations (which just linked Sect...more >>

What system table(s)/information_schema view can be used to determine if a column is part of a primary key in a table? Thanks in advance. Mark ...more >>

Hi all, I have created an application that allows user to edit a table by altering columns (length, data type etc..). I am creating a temporary column that will have all the specifications that the user wants, then insert the data from the original column into the temp column, then drop all ...more >>

Hi NG! Sql-Server: W2K3 SQL 2000 SP3 Domain: W2K3 I am having several problems using a linked server: I am using a linked server to import data from a excel-file that is stored on the sqlserver (is there another way?). I have a local windows user (member of a special group to improve secur...more >>

Hi, I have Buesiness Logic running on ASP. I want to know if theres a way of runnig ASP code by calling it from Trigger or SP ? Tnx, Ori...more >>

Hi, I'm found this sample for BACKUP DATABASE statement in SQL Server 2000 Book Online, but is seemed that only save file to server. How can I save backup file to local computer? or there is other way as easy as this statement for backup/restore database? -- Create a logical backup device f...more >>

hi all, Is that really necessary to schedule a job to reindex all tables in the database? let's say about once a month? I read an artile about since we insert, update, delete data frequenlty, schedle a job to reindex is a good pratice... any ideas or opinions? Ed ...more >>

I have an Access front-end Program that uses an MDE so I can't modify anything in it. The program links to a SQL server 2000 DB. I created a trigger on a table to prevent insertions of certain setup options. When you try to insert the options you get a huge error message and my "raise error...more >>

Are there any good tutorials on using the debugger built into Query Analyzer? Books Online doesn't seem very helpful. If anyone has any good URLs or sources, it would help, as I am working to troubleshoot some stored procedures on my server after a conversion. Thanks in advance....more >>

I am very (4 days into it) new to SQL. I have a database that is receiving data from another third party application and I have written my first trigger to alter some data in a particular field when records are transferred into the database. When I insert one record the trigger works fine bu...more >>

I have a field of date values in the form yyyymmdd and stored as int. I would like to convert them to datetime datatypes when appending to a new table, but can't get it to work. I have been trying "Convert(Varchar(30),Fieldname, 103)" but get the out of range error message. I have tried puttin...more >>

Can someone tell me how to retreive the @@rowcount value from a stored Proc that is call VIA ADO in an MS Access Project. I have declared my output variable in the Proc, and pass in a variable with my calling code, but I don't know how to retrieve the value of the OUTPUT variable. My calli...more >>

Hi there, I have a query that when run in Query Analyzer it takes around 8 to 9 seconds to run but if I put this query in a stored proc is takes forever without returning any results (no locks, it uses (nolock) and CPU/IO time is going up for process ID) It is using clustered and nonclus...more >>