Home All Groups Group Topic Archive Search About

SQL Server Tools

microsoft.public.sqlserver.tools
Score Importing data with BCP using a query...
tom.herz - 15 Apr 2006 2:15 AM - 2 messages
Hi all, I'm trying to import updated unitcosts into a products table without doing a complete dump and then reimport. I can't seem to get BCP to accept a query instead of a table -  here's the text of the command: ...
Score Blank message box in SQL Management Studio
Michael - 14 Apr 2006 7:55 PM - 1 message
Hi, I have VS.NET 2005/.NET 2.0/SQL Server 2005 on my machine. I then installed ..NET 1.1/SP1 and after installing .NET 1.0 each time I go into SQL Management studio I get a blank message box with an OK button, the caption ...
Score Which tool to use?
webrod - 14 Apr 2006 3:54 PM - 1 message
Hi, I am developping a desktop application with .NET2. This is a stand alone application. The database has to be local. I need it to store no more than 100Mo of datas. Only one user will connect to the database. ...
Score run Profiler on a specific SP/Query/Function
kevin - 14 Apr 2006 3:10 PM - 15 messages
using SQL SERVER 2K is it possible to filter Profiler to look at a specific sp. currently, I am filtering by databasename and loginname and this is pretty good.  I tried to enter % usp_mysp % in the Text but profiler kept returning ...
Score [Annoucement] Kentico Compare SQL 1.0 for Microsoft SQL Server Released
Petr Palas - 14 Apr 2006 2:12 PM - 1 message
Kentico Software has just released Kentico Compare SQL 1.0 for Microsoft SQL Server 2000 and 2005. It allows developers and administrators to easily compare the schema of database tables, stored procedures, views and functions and find differences. The product is available for introductory price of only $49 until May 15, ...
Score SQl Server 2005
Edi - 14 Apr 2006 6:08 AM - 3 messages
Is Mirroring only on SQL SERVER 2005 Enterprise Version possible or also in the standard Version.(REDO Thread ??) Is the Service Pack 1 for SQL Server 2005 available. best regard F.E. ...
Score Need Help with "System.Data.SqlClient.Sqlerror: Cannot open backup device (DLT tape) ...
frostbb - 13 Apr 2006 10:50 PM - 10 messages
We have a Win2003 Enterprise Server running two instances of Sql Server 2005.  We have 2 named instances of Sql Server 2005 up and running on the same machine. The first instance has been successfully backing up to the DLT tape system ...
Score How to activate logging on SQL Reporting Service
Steve - 13 Apr 2006 8:09 PM - 2 messages
We are getting a error "Subreport could not be shown" and were advised to check the SQL Reporting Services log.  First off, it was difficult to find.  Once we did find it, we saw that it has virtually no ...
Score Point in time restore error
DCraig - 13 Apr 2006 12:07 AM - 3 messages
SQL Server 2000 Standard edition SP4, Windows server 03, W2K and XP Pro clients. I'm setting up a recovery plan and doing some test restores.  My problem is that when I try to do a point in time restore with Enterprise Manager (EM) I ...
Score SQL 2005
Jefffff - 12 Apr 2006 8:40 PM - 4 messages
I'm trying to create a SQL Maintenance Plan to backup the databases and schedule it to run at 10:00pm every night. I can create the backup job just fine, but when I try to shedule it, I get an error saying: ...
Score Webtask-Urgent
mirzaali.abbas - 12 Apr 2006 10:31 AM - 1 message
I am using MS-Sql ServerI have created a webtask from Web Assitant Wizard . I have specified the location path as C:\Program Files\Microsoft SQL Server\ 80\Tools\WebPage1.htm but,now i want to change the location to d:\SqlWebtask\webpage1.htm ...
Score "Back up Database Task" resets the subdirectory configured by the
Titus - 12 Apr 2006 7:38 AM - 2 messages
I am using an extra drive for my SQL Server backups (instead of the standard backup directory C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup). Now I detected the following bug in the "Back up Database Task": When I ...
Score SP2 - Need your help !
gopsdwarak - 12 Apr 2006 12:20 AM - 1 message
Now that we are close to releasing SP1, we are planning to start our SP2 work. We are evaluating current known inssues to address most of the commonly reported customer bugs in our next Service pack, SP2. This can be done effectively by your active participation in providing ...
Score Error in Query Analyzer when I try to execute an update Msg 3624
dpc - 11 Apr 2006 7:55 AM - 5 messages
Server: Msg 3624, Level 20, State 1, Line 1 Location:    p:\sql\ntdbms\storeng\drs\include\record.inl:1447 Expression:    m_SizeRec > 0 && m_SizeRec <= MAXDATAROW SPID:        52 ...
Score "Specified cast is not valid" in SSMS when right-clicking table
nugget - 10 Apr 2006 10:00 PM - 4 messages
Hello: Has anyone seen this behavior? In SQL Server Management Studio (2005), I right-click a specific user-defined table.  I then get the following error: *** Error Begin - NOT PART OF ACTUAL ERROR *** =================================== Specified cast is not valid. (ObjectExplorer) ...
Score SQL Server Profiler
FredG - 10 Apr 2006 8:55 PM - 6 messages
Environment: SQL 2k sp3a running on Windows 2000 STD sp4 ASP VBScript front-end Problem: User clicks on button to retrieve a report, message from app no data found, however there is data. Troubleshooting steps: Launch Profiler Added RPC:Completed, Prepare SQL, and SQL:StmtCompleted events, ...
Score Queries spanning multiple connections
Ken - 10 Apr 2006 4:34 PM - 2 messages
I would like to run a query which reads from a table in table TA database DA on connection SQL Server WindowBox1\Srvrname1 [inner select],  and inserts the table TB in database DB on connection SQL Server WindowBox2\Srvrname2 ...
Score SQL Server 2005 Generate Scripts does not script role members any
Titus - 10 Apr 2006 11:49 AM - 4 messages
With SQL Server 2000 Enterprise Manager, it was possible to generate scripts, which included the statements to create members of server roles (sp_addsrvrolemember) and to create members of database roles (sp_addrolemember). This was very useful for replacing a server or rebuildung ...
Score "Some trace events have not been reported to SQL Profiler" - Erro
Prasad - 10 Apr 2006 11:35 AM - 2 messages
I am getting error as, "Some trace events have not been reported to SQL Profiler because the server has reached its maximum amount of available memory for the process." I know that, SQL Profiler uses 16 blocks of memory, each 64 kilobytes (KB) ...
Score ?? Turning Off TCP/IP Client Has No Effect ??
Alan Foxmore - 10 Apr 2006 2:58 AM - 2 messages
Hi Everyone, I was doing some testing with client configuration and I'm seeing something I don't understand. Let me explain the setup. My setup involves a single machine running "SQL Server Express 2005". As you probably know, SSE includes the "SQL Server Native Client". I ...
Score SQL Server Profiler and connection.Open
Sneil - 9 Apr 2006 2:23 PM - 3 messages
SQL Server 2005 + SQL Server Profiler + the client (on C#). In client as it is necessary, is connection.Open() and connection.Close() commands. I want in profiler(in tracer) to see lines of these events. How  I can adjust Profiler to  this business? ...
Score linking a far user by internet to the database
Sam - 9 Apr 2006 1:18 PM - 1 message
I have an msaccess application with back-end sql server database is someone can give me some hints what has to be done for linking  a far user ,by internet, to the database? thanks ...
Score Script Formatting Options
Tom Kelley - 9 Apr 2006 7:19 AM - 6 messages
Is there any way to set "Prefix the script with a check for existence" option (and the other options) when scripting objects from the database like we did for Query Analyzer?  I like to script individual objects and include the drop ...
Next »