Developer Newsgroups: SQL Server Tools

Object search

Kris - 31 Mar 2006 10:41 PM - 2 messages

Hi, Where can I find Object Search in SQL 2005 ?. Like in SQL 2000 we can use Oject Search( F4) from Qry Analyzer ..Any help. Thx-Kris ...

Need help on DTSTransformation/DTSLookups

desperator - 31 Mar 2006 7:12 PM - 1 message

I have a Transformation task which invokes a DTSLookups (from the ActiveX script). The lookup contains two sql statements separated by the semicolon, like this: update table1 set val = ? where id = ?; select @@ERROR, @@ROWCOUNT This is how I invoke the lookup from the vbscript: ...

Merge Replication stopping

katrin - 31 Mar 2006 5:18 PM - 3 messages

Hi, We have Merge Continuous replication. Every couple of days the Merge agent stops with an error: The process could not enumerate changes at the 'Publisher'. Source: Merge Replication Provider (Agent); Error number: -2147200999 We are running on SQL2000 Standard, SP4. The OS is Windows 2000 Server ...

Error loading file to SQL Server 2005

Robin - 31 Mar 2006 9:59 AM - 2 messages

I am trying to load a text file into SQL Server 2005 and I get the following error messages at the validation stage: Messages â€¢ Error 0xc00470fe: Data Flow Task: The product level is insufficient for ...

execute *.sql in command line

Filip De Backer - 31 Mar 2006 6:46 AM - 2 messages

Hi everyone, I want to execute more than 30 sql files in the command line. isqlw -d DatabaseName -E -f "*.sql" ---> this opens all the sql files in the query analyser. isql -d DatabaseName -E -i "*.sql" ...

Checking and Indexing

Amir Marathonian - 31 Mar 2006 1:27 AM - 2 messages

Hi, Does running the SQL maintenance tools such as indexing and checking while users are using the database cause problems? Thanks ...

Urgent! BCP command failed on SQL2000, but okay on SQL7

June - 31 Mar 2006 12:03 AM - 2 messages

Hi, Environment: Win2000, SQL2000 Both the command file and SQL2000 are installed on the same machine. I have a command file with the following SQL statement: bcp "SELECT * FROM [%dbname%].[dbo].[%1] WHERE DATEDIFF(hour,TimeStamp, DATEADD(n, -DATEPART(n,getdate()), getdate())) <=24" queryout %CurDate%.tmp ...

Re: Unable to connect to SQL Server

pradeep_raina@hotmail.com - 30 Mar 2006 5:35 PM - 1 message

I am connecting to the network server fine but my local server which is my pc i am not able to connect. ...

How to develop database locally and post to web host?

Noozer - 30 Mar 2006 6:11 AM - 5 messages

I have MSSQL 2005 Express installed locally. I've developed a database and would like to copy it to my web host to be accessed using some ASP code. Everything appears to be OK, except for one issue that I can't figure out. ...

Recovering SQL login & database

Bradley Walker - 29 Mar 2006 8:10 PM - 6 messages

Hello all, I appologize in advance if I posted in too many, or the wrong newsgroup. A client of mine contacted me earlier regarding an issue they are having with their MS SQL server. They use SQL mostly for timeclock entry for ...

Object Explorer: Scripting Default Names: How?

Dr. Network - 29 Mar 2006 7:07 PM - 1 message

In SQL 2000 Query Analyzer, when I generate a script of a table it generates the default name in addition to the default value for a column when I generate the table. In SQL 2005 Object Explorer, the default value for the ...

sql 2000 to sql 2005

John - 29 Mar 2006 4:06 PM - 2 messages

Hi How can I move a sql 2005 db (data and all) to sql server 2000? I have made the mistake of developing on sql server 2005 and now found out that production server is still 2000. Thanks Regards ...

Unable to connect to SQL Server

pradeep_raina@hotmail.com - 29 Mar 2006 2:48 PM - 2 messages

Hi I am having problem connecting to my local sql server(my machine). Though I am connecting to the network server fine but as I try to connect to Local it gives me following error. Unable to connect to SQL Server EUSD123: ...

Merging two dbs

John - 29 Mar 2006 12:34 AM - 2 messages

Hi I have two sql server 2005 dbs on server A. I need to copy all items (tables, view, sps and so on) from the two dbs into a single db on server B. The added problem is that server B is SQL Server 2000 so direct copy is ...

manutenzione, parti di ricambio, ecc. (I costi per tenere tali

cammax.drosei - 29 Mar 2006 12:09 AM - 1 message

manutenzione, parti di ricambio, ecc. (I costi per tenere tali ...

upgrade advisor not working

Jeff Larson - 27 Mar 2006 9:56 PM - 2 messages

When I attempt to launch the upgrade advisor analysis wizard and choose a server to analyze, I get the message: Upgrade Advisor could not detect SQL server components on the server. Additional information: Requested registry access is not allowed.(mscorlib) ...

ANN: Database Workbench 2.8.5 released

Martijn Tonies - 27 Mar 2006 9:27 AM - 4 messages

Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular database development tool: Database Workbench 2.8.5 has been released today! Download a trial at: [link] What's new?: [link] ...