Home All Groups Group Topic Archive Search About

SQL Server Tools

microsoft.public.sqlserver.tools
Score Documented Bug in SQL Server 2005?
John T - 4 Feb 2006 8:22 PM - 2 messages
I set up a WMI alert in SQL2K5, which invokes a response launching a job.  The alert is AUDIT_LOGIN_FAILED.  The response job is to insert the contents of the token $(WMI(TextData)) into a table. The job step text looks like: ...
Score Business Intel. Dev. Studio loads VS.Net 2005
HTML - 4 Feb 2006 5:20 PM - 2 messages
Hi, I installed the Business Intelligence Development Studio but when I run it it is just running my VS.Net 2005.  Is this what it is supposed to do?  I want to run some imports/exports and it looked like I needed that installed. ...
Score Difference between RPC:Completed and SP:Completed
peja - 4 Feb 2006 4:17 PM - 2 messages
Hi, I know that SP refers to stored procedures, and RPC to remote procedure calls, but I don't know what that means in real life. I can see in my trace files that each stored procedure has related RPC:Completed event. So why would anybody include SP:Completed event too? ...
Score (.)(.) Hot...
Se¤ÊS - 4 Feb 2006 4:15 AM - 1 message
Call +8613352960090 Free! Multi-lingual! ...
Score (.)(.) Hot...
Se¤ÊS - 4 Feb 2006 4:15 AM - 1 message
Call +8613352960090 Free! Multi-lingual! ...
Score sysprocesses vs job
Lynn - 3 Feb 2006 7:33 PM - 5 messages
Hi, Is there any way to identify job in master..sysprocesses table?  Thank you. Also, it happens all the time -- I cancelled the job, but the job processes id keep stay active all the time.  Issue KILL statement, but the processes ...
Score how to set up a 'cascading delte' in mssql
Jesper F - 2 Feb 2006 8:26 PM - 3 messages
I'm used to working with Access but have moved to MSSQL 2005. I have these tables: tblCustomer: customerID (auto), name (nvarchar,50) tblOrders: orderID (auto), customerID (int) I use SSMSE. How can I set it up so that the related records in tblOrders ...
Score Database Maintenance Error 21268
Dan - 2 Feb 2006 7:47 PM - 2 messages
SQL Server 2000 on Win2003 Database Maintenance/Optimizations generates the following error in the log: Error 21268: [SQL-DMO]Row or column specified is outside the range of the specified query result set. Which "specified query result test" is this message speaking about? ...
Score lost key
rvegas - 2 Feb 2006 7:02 PM - 2 messages
I lost the key for MSSQL ent edition. Who do I contact ? One of the guys working for me said that he called but MS would not provide him with the key. Thanx ...
Score SQL Server Management Studio Express error
Dabbler - 2 Feb 2006 5:36 PM - 3 messages
When trying to open tables in remote SQL 2000 database I get error InvalidArument=Value of '6' is not valid for 'index' Parameter name:index The database is up and running so it's not a problem with the table itself. ...
Score SQL Management Studio with SQL 2005 behind Firewall
kevinsharp69 - 2 Feb 2006 5:20 PM - 3 messages
I'm having some difficulties with remote management of our SQL server which resides behind our firewall. I'm trying to connect using the tools from my local station but it does not return the server state, so I cannot start/stop ...
Score migrate + convert data from old to new db structure in SQL 2000 with DTS
geronimo007 - 2 Feb 2006 3:55 PM - 1 message
Hi, I want to migrate + convert data from old to new db structure in SQL 2000 with DTS. The important thing I have to do is manage the transformation (not just a copy of data and structure), it is a transformation of data for use ...
Score migrate + convert data from old to new db structure in SQL 2000 with DTS
geronimo007 - 2 Feb 2006 3:55 PM - 1 message
Hi, I want to migrate + convert data from old to new db structure in SQL 2000 with DTS. The important thing I have to do is manage the transformation (not just a copy of data and structure), it is a transformation of data for use ...
Score www.verbatim.blogia.com
www.verbatim.blogia.com - 2 Feb 2006 3:38 PM - 1 message
[link] Comprar verbatim princo traxdata tdk benq , a los mejores precios. [link] Entregas Seur 24 horas. Visitanos no te arrepentiras.! [link] [link] ...
Score Animals in China
d¨l - 2 Feb 2006 1:00 PM - 1 message
mms://a805.v9135e.c9135.g.vm.akamaistream.net/7/805/9135/0029/peta.download.akamai.com/9135/downloads/jcruel_china_dog_med.wmv sa***@lpi-hk.com ...
Score Animals in China
d¨l - 2 Feb 2006 1:00 PM - 1 message
mms://a805.v9135e.c9135.g.vm.akamaistream.net/7/805/9135/0029/peta.download.akamai.com/9135/downloads/jcruel_china_dog_med.wmv sa***@lpi-hk.com ...
Score Animals in China
d¨l - 2 Feb 2006 11:46 AM - 1 message
mms://a805.v9135e.c9135.g.vm.akamaistream.net/7/805/9135/0029/peta.download.akamai.com/9135/downloads/jcruel_china_dog_med.wmv sa***@lpi-hk.com ...
Score Animals in China
d¨l - 2 Feb 2006 11:46 AM - 1 message
mms://a805.v9135e.c9135.g.vm.akamaistream.net/7/805/9135/0029/peta.download.akamai.com/9135/downloads/jcruel_china_dog_med.wmv sa***@lpi-hk.com ...
Score Invest $5,000. Get Back $80,600.00 . Get your share of the pie
Israel O.G.A. Fagbemi - 2 Feb 2006 5:11 AM - 1 message
<HTML> <HEAD> <META NAME="GENERATOR" Content="Microsoft DHTML Editing Control"> <TITLE></TITLE> </HEAD> <BODY> <P>&nbsp;<STRONG>$208 Million Magazine Project<BR></STRONG>Get your share. Earn ...
Score testhh for now
testy - 1 Feb 2006 2:55 PM - 1 message
[link] Ya puedes comprar cd y dvds verbatim traxdata princo tdk benq, a los mejores precios. Entregas por Seur 24 horas. Servicio y Calidad Visitanos!! [link] ...
Score SQL Server Manager
Bob - 1 Feb 2006 9:13 AM - 3 messages
I am seeing references on the web to SQL Server Manager [link] for example. This product wiil allow me to manager V7, 2K and 2K5 Sql Servers. I can't find it. Does it exist, or did MSDN deliberately leave it out of my ...
Score SQL Server 2005 Management Studio - SLOW
Gary L - 31 Jan 2006 5:13 PM - 2 messages
I've recently "upgraded" to SQL Server 2005 and it is painfully slow.  The management studio takes a long time to come up, opening a stored procedure or view for modification takes a long time to open, and the diagrams tool is ...
Score Query Analyzer Debuging
Microsoft - 31 Jan 2006 4:16 PM - 6 messages
Hello All, I am connecting to a SQL 2k Server SP3 on a different machine on the network using SQL Query Analyzer 8.00.760.  I do not have SQL Server installed on my machine, only the Query Analyzer.  When I try to debug a stored procedure I ...
Score SQL Server 2005 / Query Analyzer
Craig van Nieuwkerk - 31 Jan 2006 8:04 AM - 4 messages
Hi All. I have just updated the SQL 2000 Developer Edition to SQL 2005 Dev Ed on my PC. I used query analyzer exclusively in 2000 so I am sorry if these are stupid questions. 1. If I am writing a general query in the new query window (Data | New ...
Score Query analyzer and truncated result rows
tedp - 30 Jan 2006 5:50 PM - 6 messages
I'm running a query through query analyzer, outputting the results to a file in an effort to move some data from one bug tracking system to another.  Simplified down to the basics, my query looks like this: SELECT '<MyXMLTag>'+CAST(TextField AS VARCHAR(8000)) + '</MyXMLTag>' ...
Score Tools similar to Quest SQL Tuning module.
Charlie - 30 Jan 2006 4:47 PM - 6 messages
Is anyone aware of third party tools that will analyze sql statements/scripts and suggestion alternative methods of writing it similar to the Quest product? I've found a few but they are not for MSSQL. Charlie. ...
Score SQL 7.0 closes when opened
th - 30 Jan 2006 3:18 PM - 1 message
When I open sql enterprise manager on my server it automatically closes. I can run it from a remote computer with no issue. what could cause this type of behavior???? how do I fix it? ...
Score Management studio: how to script object with GRANT statements
Jan DHondt - 30 Jan 2006 1:30 PM - 3 messages
In 2000 query analyzer you could browse objects (tables, views, sprocs) right click on object en script aboject to new window. In the same right-click dropdown menu there was a 'scripting options' item, where you could check the option to also script the permissions statement (GRANT). ...
Score Help plz
Nicol - 30 Jan 2006 10:47 AM - 3 messages
Hi,     I am working in Share point service now. I created a website using share point. I worked in mining algorithms in sqlserevr 2005. I am able to view scorecard, BIp in my website. I am having a forecasting model developed using Time series algorithm in ...
Score Blank Warning Dialog - SQL Server Management Studio Express CTP
Simon - 30 Jan 2006 6:12 AM - 2 messages
When I load mgmt studio, an empty dialog pop up window appears with no text but a triangular warning symbol.  I click on ok and it launches the connection dialog without further incident. Any ideas what is causing this? ...
Score Access 2000/2002 to SQL server
Serge Myrand - 29 Jan 2006 2:25 PM - 3 messages
Hi everyones, Is there a way to migrate an Access 2000 db to SQL Server 2000 or 2005? thank you serge ...
Next »