General - SQL Server Tools

Thread preview

Thread	Last Post	Replies

oSql is adding line-breaks when "-output" or ">" is used to save output to a file.	31 Mar 2007 23:13 GMT	1
-- No line-wrapping here: PRINT '123456789 123456789 123456789 123456789 123456789 123456789 123456789 123456789' PRINT '123456789 123456789 123456789 123456789 123456789 123456789 123456789
Portable db comparison tool?	31 Mar 2007 06:30 GMT	4
Hi all... I'm wondering if anyone might be able to point me here... i couldnt find anything on google, and hope someone else has come across this... I am trying to find a tool which will allow me to compare two databases to
Generate database script does not include database role members	30 Mar 2007 14:30 GMT	3
I have read in the connect website (https://connect.microsoft.com/ SQLServer/feedback/ViewFeedback.aspx?FeedbackID=125021) That this issue was resolved in SP2. I have SP2 installed and still have the same problem.
*Connect to a remote database using QA or EM WITHOUT* ever creating CNU aliases first? (MS SQL 2000)**	30 Mar 2007 03:18 GMT	2
Accessing a hosting company's MS SQL 2000 server. I don't have any problems connecting to a remote database with Query Analyzer (QA) or Enterprise Manager (EM)... as long as I first create "aliases" using the "client network utility" (CNU).
sp_sidmap on SQL 2005	29 Mar 2007 20:10 GMT	2
I've been using sp_sidmap to remap users when moving databases from server to server in SQL 2000 without any issues. Now that I'm setting up and migrating to SQL 2005, I've encounter issues with SID's not matching and would like to run sp_sidmap to sync.
SQL 2005 Can not create Maint Plan	29 Mar 2007 17:12 GMT	1
I just installed SQL 2005 Enterprise and I can not create a maintenance plan. The server throws an error of: TITLE: Microsoft SQL Server Management Studio
conversion	27 Mar 2007 20:30 GMT	2
I want a good tool to write scripts with to convert data from a MSSQL database to any other database (possibly, but no neccasarily, also MSSQL) Anyone have any good ideas?
How to Measure TPM Tool?	26 Mar 2007 15:48 GMT	4
Does anyone know of a tool or utility that you can run against a sql 2005 server that will measure the transactions per minute on a server.
Maintenance Plan Changes in SQL Server 2005 SP2	26 Mar 2007 15:03 GMT	4
Users of SQL Server 2005 maintenance plans should be aware of a change in SP2 that affects existing cleanup tasks until updated using SQL Server SP2 tools. Who is affected?
DTS Help	23 Mar 2007 19:01 GMT	2
Right off the bat, I am brand new to using DTS. Using Enterprise Manager 8.0 I have a production db and a test db. I want to refresh several test tables for testing. I've written a package that gets each table from
Profiler: how to trace table activity?	23 Mar 2007 01:13 GMT	1
Does anybody know how to trace all activity for a specific table, using Profiler? I want to be able to trace every single SELECT, INSERT, UPDATE and DELETE for a specific table. Thank you in advance!
BCP Error w/SQL 2005	22 Mar 2007 17:20 GMT	3
In SQL Server 2000, we were able to BCP out of a table-based function with a command like this: BCP Impresario.dbo.LFT_GL_POSTING(91) out c:\impftp\gl.txt -c -T -STESS3 The version of BCP.EXE that comes with SQL Server 2005 (2005.90.1399.0)
varcharmax issue	20 Mar 2007 13:35 GMT	3
I ran into an issue with varcharmax and I was wondering if anyone knows about this If you look at a file exported from sql mgmt studio it exports the line in the create statement for a varcharmax field as
A good Database Modelling Tool for Sql Server 2005	20 Mar 2007 00:11 GMT	4
Hello i am looking for a good database modelling tool in order to design an sql server database. I have recently come across with DBDesigner 4. Can you suggest me a better alternative?
Different link	19 Mar 2007 11:22 GMT	2
Thanks, but this is the link I went to listed above. It does not explicitly say you can install the tools on a client box without a license if you have a server license. You can infer that from what it says, but I would really like to find it spelled out.