Microsoft SQL Server Forum

I have uses DTS Import/Export wizard to export all my tables from one databse to another on the same server. How do I export all of my stored procedures and UDFs? Thanks, lq

In a stored procedure (SP1) I am looping through a cursor with records from Table1. Each record in the cursor is inserted into Table2. Insert trigger on Table2 is inserting the record into Table3 (in another DB). In the insert trigger on Table3, a series on checks are done on the inserted record and in case of an error, an email is sent and...

Hi! My tempdb crashed. What is the correct way to restore it? I heard that it should be restored in a special way. Thank you.

I have created an Access2K front end application that connects to a SQLServer2K backend. I use this vba code to create the connection from the Access app: Dim strConnect As String 'make sure all previous connections are closed: CurrentProject.OpenConnection "Provider=" 'create new connection string to server: strConnect =...

Hi guys, after long long time. i'm back again with another problem. this time i think the problem is very very interesting and i really need you help on this. i'm trying to connect to the Active Directory. for that i've added one linked server to connect to the active directory. and then query like this: adding linked server:

Hi i need a stored procedure in an sql server, that inserts a query and returns a int value. the int value is an id made of a auto increment (identity(1,1) field. i have no clue how to do that.

Hi All, I am not so proficient in SQL and seek your help. I have a column by the name of Mask in a table, which has text eg. (YYYYYYYNNNNYYYYYYYYYNNYYYY). I wanted to update one particular value in that text. How would my update statement look like? Below is my select statement.

Hello I have questions about how works transaction log et the database tempdb in SQL Server and I hop you could help me - Is it possible to reduce the size of the transaction log fil during an execution ? Indeed, I have a script inserting a very large quantity of data (many Go) and during that process my transaction log file use all the...

Hi! I would be grateful for any advise regarding what I'm doing wrong.. My brain is stuck. Probably some stupid simple mistake I don't see. Thanks very much for your efforts! Martin I have this code: DECLARE @ContactID varchar(10),

I've a table where there are 4 columns for Qty(Q1, Q2, Q3, Q4) and another column as Virtual_Pack. I've to write a query to update Virtual_Pack column. The logic is as follows 1 virtual pack consists of Q1 = 10, Q2 = 2, Q3 = 3.5, Q4 = 6 Lets say Q1 = 20, Q2 = 2, Q3 = 20, Q4 = 6 then the Virtual_Pack will be = 1 because Q2 = 2 Example...

Hello, I have a table as shown below. I need to write a sql query that tells me what courses are common between Tom and Jim. Name CourseID ------------- Tom 1 Tom 2 Tom 3 Jim 1

Hi Gurus... CREATE TABLE ( NOT NULL , NOT NULL , NOT NULL , CONSTRAINT PRIMARY KEY CLUSTERED ( ,

test

Hi! Stupid question as this also depends on hardware but is there a limit on how many rows I can have in a single MSSQL 2000 table? Table consists of six int columns and has three indexes. Is like 10 Million or 100 Million considered to be 'normal' or unrealistic? Thanks very much for your thoughts! Martin

I have content about projects that I store in a MS SQL database. People access this information through pages which are dynamically created in PHP. Since my content is stored in the database, how can I get google web search (at google.com) to included that content when it indexes my site? Is it a possibility? Thank you so much!

Hi, I have a table with the following data city_id issue_id region c1 i1 South c2 i1 South c3 i2 South c4 i3 South c5 i1 North

Hi all, I have the following table to log events as they happen: EventID UserID Event Time ====== ===== ==== ==== 1 User 1 Login 08:00:00 2 User 1 Logout 11:00:00 3 User 1 Login 13:00:00 4 User 1 Logout 16:00:00

hi all, i want to develop some script to configure sql externally, can anyone tell me how can i do so?? and wether this is possible or not?????? the type of configurations that i need, setting sa password, deleting guest account,Remove sample databases, Audit Login events, Restrict CmdExec rights to SysAdmins,... i want to develop a...

Every night i want to send the new records that are created from my remote client to my FTP site, using a application which sets up an internet connection on the client , exports the data to the flat file and downloads the flat file to an FTP site. Would anyone know how to do this? Thanks in anticipation.

Hey guys, Couldn't find this anywhere in google. I want a list of all database column names for a specific table/view from across database. I tried this... ----------------------------------------------------- Select *

Hi, I have a table with composite key: ID1 and ID2 and it also has a priority field. I want to get all the information for all records with the minimum priority group by ID2. How can I achieve that? Thanks.

Hello I have questions about how works transaction log et the database tempdb in SQL Server and I hop you could help me - Is it possible to reduce the size of the transaction log fil during an execution ? Indeed, I have a script inserting a very large quantity of data (many Go) and during that process my transaction log file use all the...

Hello, I have questions about SQL Server and I hope you could help me a lot. - Is it possible to reduce the size of my transaction log file during the execution of a sql script ? Indeed, my sql script work with very large table and my transaction log file use all the space on my hard drive. so the script have to stop with an error. - Is it...

hi. i want to make a table in sql server 2005 and i want that there should be two columns one if date and other for time...... i want that date column should show only date but not time and the time column should show only time not date...... i tried this but when i enter only time it shows date also n that is 1900-01-01 and when i enter...

I have several sql server databases that were recently moved to a new server. In the process of migrating the databases, any triggers and constraints attached to tables were removed on accident. I need to add these objects back into the databases, however I'm worried that I will have problems with referential integrity since there is a...