Search results for query: *

Thank you very much for the posts. If I want to get the jobs concurrently run between a given time say I give 2 inputs date1 and date2 .Will adding the date condition to mjia's query server the purpose? Thanks Bill

Thanks for the posts I need to get a list as to which had already completed Sorry for the miscommunication. Like say where at, on july 25 12pm which were all concurrently running? Thanks Bill

I have a table which stores jobs. Jobs has columns: jbid submitdate enddate dates stored as: submitdate 2004-07-27 16:08:19.757 --- --- enddate 2004-07-27 16:10:19.757 -- 2004-07-27 10:18:19.757 Some Jobs overlap.I need to display the jobs that are concurrently...

Hi, I have some databases where the properties - Torn page detection and Auto update statistics is turned off. Will there be any problem if I turn it on (through Ent.Mgr) when the databse is in use(When users are connected to the database)? Thanks in advance Bill

Hi, Iam taking the output of a query to a text file.I used bcp ...queryout filename for that.This is working fine In the text file I need to get the query result with some heading and footers like : command1 row1 row2 --- --- command2 command3 command4 Actually this text file later need to be...

Hi, Thanks for the info.The bakfiles have same date but time may be different like test200309270126 which indicates that this backup was taken at 1.26 on 27th sep.I have sql 2000 on both servers. I will try detach and attach and see whther that will do the purpose. Thanks Bill

Hi , I have a new server and I want to move all the SQL databases,logins ,jobs etc to the new server while retaining all in the old server,that is the old server need to run as it is .I have backups all of the databases, more than 250 dbs,but they have the date as the suffix of the .bak...

Hi, I need to change the recovery model of some databases from simple to full in EM.Will it have any adverse effect on the database or users connected in a prod server thats currently running.Please advise Thanks Bill

Hi, I have multiple datbases (> 100) and I want to do a backup of the data/t-log of all the databases. Can I do it by any other way ,for all the databases other than a maintenance plan (rather than doing for each one).Currently tlog backups of some of the databases are failing.The error is...

John, Please check SQL Server BOL.Adding multiple columns using ALTER TABLE is possible Bill

Hi, I had posted this once and couldnt get a SQL solution The DB in question is an ACCESS 2000 DB having a table named client having a field which stores client names. This field can have any character in it. The problem is to find names avoiding non alphanumeric characters from it. Pls...

Hi, Thank you for the post.Is there any single SQL thatcan be used without the function ? Can somebody help ? Thanks Bill

Hi , The DB in question is an ACCESS 2000 DB having a table named client having a field which stores client names. This field can have any character in it. The problem is to find names avoiding non alphanumeric characters from it. Pls consider the following example data client_name...

Hi, The DB in question is an ACCESS 2000 DB having a table named client having a field which stores client names. This field can have any character in it. The problem is to find names avoiding non alphanumeric characters from it. Pls consider the following example data client_name -----------...

First table (table1) contains approx 20,000 rows and the second contains less than 200.Almost 3 colums are selected from both tables and 3 from a 3rd table.It has a left join and 2 innerjoins and criteria is table1.timestamp not null. That query was only a specific scenario that I presented.I...

Hi, Iam trying to optimize some queries and views.When I run the queries and view the execution plan, it shows clustered Index scan for some tables.For eg. table1 may have a PK and in the execution plan it shows it is using that, as table1.pkindexname.The query may have another column (col2)of...

Thanks, That worked.But now the problem is with the ownership. How can Make it work ,when somebody else executes it ? Bill

Hi, I have created a DTS to move data from SQL to Access database which is in a net work drive.It works fine in my system, but if I run it from another nachine ,as the drive mapping is different ,it fails. (if I change the drive mapping it works)Is there a work around for this so that...

Hi terry, Sorry for the delay. It is a text field that Iam inserting into.I would like to do it thru a program ,only once. Yes,I have tried attaching the file and it works.But I have to store the contents of the file in a field. Thats what Iam aiming at. Thanks Bill

The length of the message varies ,Its actually textual matter the smallest is a file with 40 lines. I tried using bulk insert , but didnt work.Its that each file is to be taken as message for each user. (but first must be stored in a field) Thnks bill