Home All Groups Group Topic Archive Search About

SQL Server Tools

microsoft.public.sqlserver.tools
Score ! Distributing DMO For SQL 2000 !
Lee - 26 May 2006 6:22 PM - 4 messages
I am having a problem getting SQL DMO to install on a clients machine. Not that it matters, but MSDE 7.0 is also present on the machine. I built the install with visual studio 2005. Using the information from the "REDIST.TXT" ...
Score SQL Server 2005 SMTP and POP3 - Suggested Reading Please...
Mark Micallef - 26 May 2006 4:01 AM - 1 message
I'm interesting in learning more about the capabilities of SQL Server 2005 integration with POP3 mail servers, but I'm having difficulty finding any good articles on the net.  I'm especially interested in (1) how the server is configured to retrieve emails from a POP3 server, and ...
Score iam creating a automated sql security
MrRAO - 26 May 2006 12:06 AM - 2 messages
how to find the regestry key for the following : * sql server authentication * sql server authentication * find the users list * find the users password Because while starting my wizard i have make sure to check these above checks . or Is there any configuration and monitoring tool to check the sql server 2000 ...
Score Can we specify the format of the date field in Format file
Veeru - 25 May 2006 5:41 AM - 1 message
Hi We are using Format files to load the flat file data into the table in SQL server 2005 and using bcp utility (version 9.0). Can we specify the format of the date field in Format file to load the date ...
Score Validations in bcp format file
Veeru - 25 May 2006 5:34 AM - 2 messages
Hi I need few clarifications. I am using bcp 9.0 tool to load the data into the table in SQL Server 2005. Can we do validations in bcp format file. The validations like 1. if the datafile field data is "ABC" I want to insert the data into table ...
Score OSQL format to structured table in cmd prompt
Gangadhar Rao Kandregula - 24 May 2006 10:45 PM - 2 messages
Hi , Iam working on an application which queries out all the T-SQL command from a *.txt file to *.csv file . OSQL -U usename -P password -i xxx/file1.txt  -o yyy/file.csv -n -dmaster but what happens is ----all the data is not arranging as individual tables ...
Score table
anonimo - 24 May 2006 4:35 PM - 2 messages
is there any way to see if a table was modified ? if was using an insert, delete or update? thanks. ...
Score Registering SQL DMO For SQL 2000
Lee - 24 May 2006 1:52 PM - 6 messages
I have run into a couple of machines that will not register the SQL DMO for SQL 2000. When attempting to register the following error occurs... SQLDMO.DLL failed to register. HRESULT -2147024770 Any Ideas? ...
Score USAGE OF DECODE STATEMENT IN FORMAT FILE OF BCP UTILITY
JP - 24 May 2006 1:33 PM - 2 messages
Hi I think we have CASE statement in SQL server which is an equivalent of  a decode statement in Oracle. Is this correct? Do we have any other statement in SQL server that is an equivalent of a decode statement in Oracle? ...
Score Can we assign constant values or default values in format file
JP - 24 May 2006 1:21 PM - 1 message
We are using BCP tool to insert the flat file data into the table. we are using format file to map the fields of flat file to the columns of table. Can we assign constant values or default values in format file of SQL server ...
Score insert more than one record in table for a onerecord in the flat
JP - 24 May 2006 1:15 PM - 2 messages
We are using BCP ulility to insert the flat file data into the table. Can we insert more than one record in the table for a single record in the flat file? E.g. Flat File data ------------------ 1200|ABC|XYZ|1000|2000 ...
Score Downgrade from SQL Server 2005 to 2000
DJFunkenstien - 24 May 2006 8:20 AM - 3 messages
Hey Folks, As above, any ideas how to DOWNGRADE -- from SQL Server 2005 db to 2000? I'd appreciate any cool ideas. Thanks ahead ...
Score SQL 2005 Template question
TomT - 24 May 2006 12:49 AM - 4 messages
In Template Explorer, I modified the Create Procedure (New Menu) template, and when I open it, I see the modifications. However, when I create a new sp, the original template (before I modified it) is used. What am I missing here? ...
Score EM Current Activity
Thom - 23 May 2006 6:59 PM - 5 messages
What permissions does a user need to be able to open the Current Activity pane in EM for SQL 2000?  I have a user that is wanting to monitor their own processes for blocking and also to make sure it is doing something. ...
Score Master sys.xp_delete_file not found?
CarlT - 23 May 2006 3:29 PM - 6 messages
Please I need help in removing older database backups using SSIS. I do not want to remove these backups manually every day. I have tried to use the tools supplied with SQL 2005 and as far as I can tell they just don't work. ...
Score BI Development Studio - VS 2005
SQLfun - 23 May 2006 2:58 PM - 5 messages
Newbie question: Does BIDS require VS 2005? I installed sql server 2005 evaluation version, BIDS points to devenv.exe under VS 8, does that mean I have to install VS 2005 in order to use BIDS? Is it possible to use BIDS ...
Score Earn up to 1000 $ per month only for reading your Mails!!!!!!!!
ADMIN - 23 May 2006 2:30 PM - 1 message
<HTML> <HEAD> <META NAME="GENERATOR" Content="Microsoft DHTML Editing Control"> <TITLE></TITLE> </HEAD> <BODY> <P>&nbsp;</P> </BODY> </HTML> ...
Score BCP/OSQL
DEva - 23 May 2006 10:06 AM - 4 messages
Hi I have a big project before me on bcp and i never worked before on .cmd files. I am basically developing an interface sql server(server B)  between two sql server(say server a and c) . server 'b' extracts data from 'a' using bcp and the flatfiles so extracted ...
Score Running SSIS Package using a scheduled Job in SQL2005
Manjunath Basrur - 23 May 2006 6:53 AM - 4 messages
Hi, I have created a SSIS package. The connection used in the SSIS is SQL Authenticated. This runs perfectly when executed even after it is deployed. However, I face problems when I want to execute this package as a job. The ...
Score The Data Miner: SQL Server Data Mining Newsletter (May 2006)
Raman Iyer [MS] - 22 May 2006 9:00 PM - 1 message
the data miner        sql server data mining news      may 2006 Welcome to the May 2006 issue of 'The Data Miner' - the official newsletter of SQL Server Data Mining. This periodic newsletter keeps you up-to-date with the latest happenings in the SQL Server Data Mining world and gives you useful tips to help you get the most from SQL Server Data Mining. ...
Score Best tools to manage/use SQL server databases
Halim Boumedjirek - 22 May 2006 7:28 PM - 1 message
Do you think EMS SQL manager 2005  for SQL Server is a complete tool to manage SQL server databases? We used to use IBexperts for Firebird and it was a great tool. I downloaded the trial version of EMS SQL manager for SQL server and it looks exactly ...
Score mysql to SQL Server Tool
Samuel Shulman - 22 May 2006 7:22 PM - 3 messages
Hi I am looking to migrate mysql to SQL Server any good tool to do that My DTS wizard doesn't give the option of mysql Thank you, Samuel ...
Score SSMS05 diagram scrollbar problem
PJ6 - 22 May 2006 6:06 PM - 1 message
This is really annoying - when I close and then re-open a diagram, all the table elements show double scrollbars unnecessarily unless they are way oversized. And all this time I was hoping for an auto-size feature where I ...
Score ANN: Database Workbench 2.8.6 released
Martijn Tonies - 22 May 2006 6:27 AM - 1 message
Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular database development tool: Database Workbench 2.8.6 has been released today! Download a trial at: [link] What's new?: [link] ...
Next »