Rating Thread / Thread Starter	Last Post	Replies	Views
Is there a way to execute a DTS package for SQL Server through OLEDB Hi I am tryin to figure out if it is possible to execute a DTS package( either file or stored within the SQL server itself ) using OLEDB. I see... Mac Dyer	12-14-2004 07:28 PM Dan Guzman	1	48
SQL Deadlock? When I run ACT (just spin up a bunch of threads) and try to simulate alot of users hitting on the database at the same time I get: 1205 Source:... Kevin Burton	12-14-2004 06:41 PM Greg Linwood	2	74
Diagram I'm wondering what kind of image type SQL database diagrams are? The thing is that I have a SQL database documentation application that... Kenny	12-14-2004 06:39 PM Kenny	2	58
Why running the same query after the first time is faster ? ( 1 2 ) I have SQL Server 2000 database that has about 8.5 million records. The database has 1 table, and the table has 4 columns. CREATE TABLE . ( ... Paul fpvt2	12-14-2004 05:41 PM Paul fpvt2	11	71
SQL Server Schedule Jobs Fails All of a sudden my schedule jobs failed. Only non maintenance schedule jobs continue to work. All other scheduled jobs have failed with the... Perplexed	12-14-2004 04:54 PM John Bell	3	52
update not working This may not be the right place for this but can someone help me out? The following code is in MS Access, and it's not updating. UPDATE SET... ae	12-14-2004 04:51 PM ae	7	48
Group by clause with Case How come: INSERT INTO... tshad	12-14-2004 04:45 PM tshad	6	55
Error executing DTS package from Stored Procedure I have a stored procedure create for the sole purpose of launching a DTS package. I can post the SQL later if necessary. The problem is that I have... ATJaguarX	12-14-2004 04:25 PM ATJaguarX	0	43
Primary key on temp table not unique? Hi folks -- Given the following code: ALTER TABLE #TEMP WITH NOCHECK ADD CONSTRAINT PK_TEMP PRIMARY KEY CLUSTERED (StudentID) ON If two users... Carl Imthurn	12-14-2004 04:19 PM Anith Sen	8	55
Ways to avoid never ending "rollback" Hi all of us, I had a job running since yesterday evening and it bring spent almost thirteen fucking hours so finally i've decided apply a when I saw... Enric	12-14-2004 04:08 PM Hugo Kornelis	1	45
DTS Package and Identity Fields I am creating a DTS package to import from a text file into a table on my SQL 2000 database. I used the Import Data Wizard, saving as a DTS... Joshua Campbell	12-14-2004 03:58 PM Joshua Campbell	4	54
DOS Batch File in SQL Does anyone know how to execute/embed DOS Batch command using a SQL Store proc? I have SQL command that runs via the scheduler and creates 2 .txt... J. Joshi	12-14-2004 03:30 PM Andrew J. Kelly	2	52
pessimistic locking i have a table A with a field B iam updating a row say where B = 1 when iam updating this row i do not want another user updating this row at the... Preeta	12-14-2004 03:21 PM Preeta	7	46
ado hierarchcial shaping question Hi, Quick Question...concerning case sensitivity between 2 tables They are related on a char field that is case sensitive named RCP_GROUP (Are there... ben s	12-14-2004 02:53 PM ben s	0	49
KILL and sp_who I've got a nightly job that refreshes a development database from our production database. The problem I'm having is that some people leave at night... jmeyers	12-14-2004 02:53 PM jmeyers	3	57
High CPU - Hello, My production SQL Server has very high CPU utilization. I/O and Memory are in normal state. There are not many blockings are deadlocks... Kam	12-14-2004 02:47 PM Gert-Jan Strik	4	48
Put Results of xp_trace_getappfilter in Temp Table (SQL 7) Can someone help figure out how to get the results of xp_trace_getappfilter into a temp table. This particular xp generates a result set with three... David Gugick	12-14-2004 02:19 PM David Gugick	0	40
Find all search terms in any table I'm implementing a simple "keyword" search capability such that if the user enters "mouse trap", all records will be returned that have all those... Mark Wilden	12-14-2004 02:18 PM Mark Wilden	5	53
Deleting rows using SQLDMO I have to copy the contents from one database to another database each night. I have created VB app using DMO and DTS. I create a list of... Dean	12-14-2004 02:17 PM Alejandro Mesa	3	37
Diagram re-arranging tables I have a diagram with 2 tables on a second page. I find that anytime I make any change at all to the diagram - it takes the whole diagram and... tshad	12-14-2004 01:40 PM tshad	2	45
Statistics. Hi Sql Gurus, From Inside Sql Server The histogram is created when the index is created on existing data, and the values are refreshed each... PVR	12-14-2004 01:21 PM Alejandro Mesa	1	64
Diagram relationships Is there a way to tell the diagram not to show the relationships? I want to just print out the tables with the field definitions in alphabetical... tshad	12-14-2004 01:11 PM Anith Sen	1	48
stored proc returning common value from multiple tables I am working on writing a stored proc to QC the load of some tables. The load is done monthly, so I want to compare the count from last month's... Andy	12-14-2004 01:07 PM Alejandro Mesa	1	48
Where does DTS info saved? Hi Freinds, SQL2000 Where does DTS info saved? Which database? master? msdb? which tables? Thanks, Pat Patrick	12-14-2004 12:55 PM Alejandro Mesa	1	53
DB size 5GB?? Hi to all. My DB size is over 5GB. This size doesn't make any sense. How can i see the amount of space, each object takes? Thanks, Sharon. Sharon	12-14-2004 12:15 PM Andrew J. Kelly	7	48
Performance Questions Hi Sql Gurus, If I have a Bulk Copy Opertion.. Performance wise which will be the best. 1 Create Table Insert Data Create Clustered... PVR	12-14-2004 12:13 PM Andrew J. Kelly	5	44
SP Performance Question? Could I have written the following stored procedure better in which I may benefit regarding performance or cleaner code? or do the following sp... Leon	12-14-2004 11:47 AM Leon	4	42
Can Not Access DB ( 1 2 ) I can not access my SQL database objects. Unless I now state the user.tablename What have I changed. I get the same error with our SA user as... Graham	12-14-2004 11:46 AM Aaron [SQL Server MVP]	11	84
views returning wrong columns Using SQL Server 2000, SP3. Try this : == create database junk GO use junk create table a (apk int primary key, a1 varchar(10), a2... Stephen Ahn	12-14-2004 11:40 AM Gert-Jan Strik	4	36
Diagram showing field types Is there a way to have a diagram show the field types? I would like to use it for my documentation instead of having to hand write it. Thanks, Tom. tshad	12-14-2004 11:39 AM tshad	3	36
Need Query Help Then you'll have to explain what you want, preferably with table definitions, sample data, and desired output. The query Adam and I suggested does... agarrettb@hotmail.com	12-14-2004 11:29 AM agarrettb@hotmail.com	3	41
Stored procedure constraint violations anHi All, I have a stored procedure that is doing some purging of data from our database. When we try to delete a record that violates a foreign... John Oberkehr	12-14-2004 11:25 AM John Oberkehr	2	37
Querying for parent records whose child records all have the same value. I have a table that represents a parent (crt_actn_id) / child (rcvbl_id) relationship. There is a status code for the child on the table. What I want... Dave Akin	12-14-2004 11:20 AM DWalker	5	37
sql error I'm getting this error when I run a stored procedure: ConnectionRead (WrapperRead()). Server: Msg 11, Level 16, State 1, Line 0 General network... Doug Stiers	12-14-2004 11:19 AM mark baekdal	2	46
Please explain why this Select doesn't fail ( 1 2 ) I discovered that I had a wrong field name in a Select, and I was essentially doing an invalid select. Translated to the Pubs table, here's what I... DWalker	12-14-2004 11:18 AM DWalker	14	82
Recreating a database??? Hi, Is it possible to create a package using Enterprise Manager or something else that will recreate a database! I want to create a kind of... Tim::..	12-14-2004 11:15 AM mark baekdal	2	42
cursor doesn't work Thanks one and all. I've got it set. "Alejandro Mesa" wrote: Boomer JM	12-14-2004 11:09 AM Alejandro Mesa	7	45
dynamic select my query looks like this: select sum(@fields) from table_name ...... @fields = a*b a and b being field inthe table. what should be the type of... Preeta	12-14-2004 11:04 AM Gregory A. Larsen	5	44
Cannot access output of sp_executesql Hi all - I have the following: SET @FinalSelectString = (@SelectStringPrice + @InnerJoinString + @QueryStringParts + @QueryStringParms +... Michael.Fisher	12-14-2004 10:29 AM Michael.Fisher	7	39
any thoughts about how i can design this import system...? Hi all, I'm writing a sql based import system that imports data from a view to a one or serveral tables in the target database. Its the final stage... pauly	12-14-2004 10:20 AM pauly	2	44
One or the other I have to deal with the way different brokers provide references for our clients. Some provide just one for everything and others one ref... James	12-14-2004 09:28 AM	2	42
Query help (JOIN on own table) Hi! I have the following table: CREATE TABLE source ( id int not null, value varchar, source varchar not null ) Nils Magnus Englund	12-14-2004 09:19 AM Alejandro Mesa	5	40
Query help (JOIN on same table) Hi! I have the following table: CREATE TABLE source ( id int not null, value varchar, source varchar not null ) Nils Magnus Englund	12-14-2004 08:55 AM Nils Magnus Englund	1	31
all about transaction ( 1 2 ) Hi, can anybody tell me any website or resource from where i will get all information about transactions. not the sql server one but the... Deepson Thomas	12-14-2004 08:39 AM Hugo Kornelis	16	68
Problem on dev server Hi everyone, We have a development server (has virtually no load) and a live server. The dev server is a new one and is better than the live server... Ishan Bhalla	12-14-2004 08:30 AM Andrew J. Kelly	5	46
Convert TimeStamp to DateTime have different behaviors on different databases Hello Im having a different behavior when using the convert timestamp to datetime on two diferent databases on the same server. In one... ce.souza@gmail.com	12-14-2004 08:14 AM Aaron [SQL Server MVP]	2	34
Update tables with a sproc Is it possible to update a field in a stored procedure that contains a join? For example: (ManufSerNo is contained in Asset table, Status is... Scott	12-14-2004 08:06 AM Vishal Khajuria Udhampuri	2	42
Trigger for future checking Dear Friends I want to write a trigger which will be fire on update and delete. I have a table with 12 fields. I have created a backup table with... Sharad	12-14-2004 07:51 AM Mike Epprecht (SQL MVP)	1	46
Date format problem I am having simple qry Select * from matches where start_date >= '01/02/2004' Now on one the server date setting is dd/mm/yyyy format and on... manisha_css	12-14-2004 07:32 AM Uri Dimant	4	42
sp_changedbowner fails in script Hello All, Can anyone shed some light on why this vb script fails to pass the parameter value to the stored proc? It returns the following... Richard C.	12-14-2004 07:04 AM Richard C.	4	47

Page 1056 of 1545

1056

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off