SQL Server Tools

Hi guys, Hope some of you SQL database experts out there can help me, 'cos at the moment I'm going mad! I want to use ACT! 2008 which uses MSSQL  on 2 Laptops, (Vista & XP) one is ...

What ports do i need to unblock on client and server (running msvsmon.exe) to debug remotely from my client box with visual studio 2005 pro? When I attach to remote process a connection shows up in msvsmon.exe on the ...

I am trying to install SQL Server 2005 Management Studio on my system. I had SQL Server Express, with Management Studio Express, installed before. The SQL installer allowed me to upgrade the SQL Server engine, but it said that I had a different version of Management Studio installed and blocked ...

hello, I am trying to figure out how to draw a 1:1 relationship in a database diagram (or with foreign keys) from visual studio 2005. in the books online it explains one-to-one relationships and even shows one ...

Similar to my earlier SQLCMD/OSQL question, I have some BCP commands that I need to run on SQL Server 7. The command produces pipe- delimited output, but that's just an override on the separator character, and in SQL Server 7 <NULL> values come out as a single ...

Profiler (this is SQL Server 2005 SP2 with rollups) is reporting some interesting duration values for stored procedure execution: StartTime: 2007-11-01 10:17:58.180. EndTime: 2007-11-01 10:17:58.180. Duration: 18446744073709532 I wonder if anyone else has seen this, or is my server just doing a bit of ...

how to determine how many milliseconds a segment of code takes to execute in TSQL on sql server 2005? ...

I have a set of extract scripts that I can run using SQLCMD, but I need to run them on a SQL Server 7 database server. SQLS7 doesn't have SQLCMD, but it does have OSQL. This leaves me with some challenges: ...

Hello, I have been looking for a web-based import script/tool that will allow someone to browse for and select a local source file and on submission to the "form" parse the source file into a destination database. I've found some ...

Hi-- I just started to work with Microsoft SQL Sever Management Studio Express (2005). The File menu gives me the option to Save Results As... to output my query results, but the results come out as CSV which is causing problems (a ...

Is there any reason why an SSIS package can't be used to connect to an SQL Server 7 database and extract data from it? Phil Hibbs. ...

This likely is a stupid question, but I am looking for a tool to import email into SQL Server.  We have a mailing list that is entirely web based, and we want folks to have the ability to reply to the email and have that be ...