Developer Newsgroups: SQL Server Tools

SQL 2005 Table setup

Jonathan Beck - 31 Dec 2005 5:01 AM - 3 messages

I'm migrating a MySQL db to a MS SQL 2005 db. I'm using visual studio 2005 for development and remote db admin. Is there any way short of developing code to import a table which includes all the data. ...

creating unique index and clustered index in sql server management studio

gary - 30 Dec 2005 8:18 PM - 9 messages

Hello, I have run across a very strange situation. If i use the management studio to change an index that is clustered is does not actually change the index. It shows up in the gui as changed, but the ...

SQL Server 2005 and Express 2005 BOL

C_Hudson - 30 Dec 2005 7:33 PM - 2 messages

When I installed SQL Server Express 2005 I also installed Management Studio Express CTP and Express BOL. I then installed .Net 2 framework and SQL Server 2005 BOL, at which point Management Studio app no longer ran. De-installed SQL Server 2005 BOL and re-installed Management Studio Express, ...

Insert picture

vul - 30 Dec 2005 5:21 PM - 2 messages

Access allows to insert manually an image into OLE Object type field very easy. I was wondering if there is a simple way to insert an image into image type field in SQL Server using Enterprise Manager (not programmatically) Thank you ...

SQL 2005: T-SQL does not support breakpoint condidtions

LvBohemian - 30 Dec 2005 5:21 PM - 2 messages

When attempting to select the breakpoint condition from within the VS05 RTM IDE I get the following error message: "T-SQL does not support breakpoint condidtions" What's up with that? Also, why the heck would you not be able to debug TSQL from "SQL Server ...

different results query analizer vs. enterprise manager

peppi911 - 30 Dec 2005 3:51 PM - 3 messages

hi, i have a query which i run in query analyzer. if i copy it to the enterprise manager it rearranges my query. this is not a problem for me, but the result is different, there are different numbers of rows given back. ...

modifying stored procedure with SSMSE

Jesper F - 30 Dec 2005 3:40 PM - 9 messages

I have a MSSQL 2000 db that was imported into SQL2005. I use the Management Studio to administer the database. When I modify a stored procedure and hit "save" I'm asked to save a file called something like "SQLQuery10.sql" to a place on my own harddrive!? I ...

Management Studio Settings?

Jeff B - 30 Dec 2005 1:17 PM - 2 messages

I apologize in advance if these questions seem a bit simplistic, but I am just starting out using the SQL 2005 Management Studio. Is there a way to have windows that are opened up to restore back to their previous positions ...

Profiler Question

PhxSam - 29 Dec 2005 11:01 PM - 3 messages

While analyzing a production trace, I noticed that the duration on SP:Completed was 1300 ms, but the duration for RPC:Completed was 27312 ms (for the same proc). I am trying to understand where this time is being ...

Management Studio oddity (Bug?)

Mark - 29 Dec 2005 10:38 PM - 2 messages

I am unable to modify any table valued function from mangement studio. I am the system administrator for this database and wrote the function. Query analyzer allows me to edit it. Dows anyone had similar experiences? Error message: "Property QuotedIdentifierStatus is not available for UserDefinedFunction ...

Query Analyzer won't let me edit grid data in 2000

David Bienstock - 29 Dec 2005 6:51 PM - 8 messages

I looked at the help for possible reasons but this is not a lock, rights, index, cluster, primary key, or SP4/version problem. I can't even do a "select * from authors" in pubs and have it be editable. ...

Taskpane Error

Max Yaffe - 29 Dec 2005 3:36 PM - 2 messages

I'm trying to use the Taskpane to get an overview of databases in Enterprise Manager. Often it gives an error: Internet Explorer Script Error Line: 307, Char: 2, Error: Unspecified, Code: 0, URL: res://C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Binn\Resources\1033\sqlmmc.rll/Tabs.html ...

SSMSE Help is missing

todderickson - 29 Dec 2005 2:49 PM - 2 messages

I have the newest December CTP of SSMSE and the newest December SQL Server 2005 Books Online installed on my system, however BOL is not integrated into the SSMSE help. I can't get context sensitive help when I am working on a query and BOL is not available on the Help menu. ...

mgmt studio-View user permissions?

Bob - 29 Dec 2005 4:06 AM - 4 messages

Using SQL server 2000 Enterprise Manager, one can bring up the properties of a database user, click the Permissions button, and see all the permissions that have been set for Stored Procs, tables etc... One can modify these as ...

sql 2005: statement that will call another script

Trex - 28 Dec 2005 4:21 PM - 2 messages

Is there a t-sql statement I can use to run another script? Can I call sqlcmd from within a script? ...

Server Memory usage\Performance problem

Magnus Österberg - 28 Dec 2005 3:08 PM - 4 messages

I am experiencing the following problem; I boot my Windows 2000 sp#4 machine to get a fresh machine. The hardware is Pentium 4, 3 ghz with 512 mb RAM. There are no other heavy applications running on the machine. ...

command line tools to make flat backups

melson - 28 Dec 2005 5:28 AM - 3 messages

Does anyone know if there is a way to run a command at the DOS prompt to make a complete flat file (.bak) backup of a database? I know you can do this using the enterprise manager by right clicking on the ...

Determine which Linked Servers or Remote Servers are being used

stephendl - 27 Dec 2005 7:01 PM - 2 messages

Hello, I did some searching but couldn't find an answer to help me discover which of the Linked Servers and/or Remote Servers on our instances are being used. I wish I could delete them and wait for users to scream, ...

I cannot connect to SSIS service

Dante P - 27 Dec 2005 3:35 PM - 1 message

My error is: TITLE: Connect to Server ------------------------------ Cannot connect to TS20. ------------------------------ ADDITIONAL INFORMATION: Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum) For help, click: [link] ...

Unable to view diagrams in Enterprise Manager

David Carr - 26 Dec 2005 10:54 PM - 2 messages

I am having trouble viewing diagrams on a SQL Server through Enterprise Manager. I created these diagrams a few weeks ago. The names of the diagrams are visible, however opening the diagram in EM to look at it has ...

New release of SqlClrProject

Niels Berglund - 26 Dec 2005 1:54 PM - 2 messages

I thought I better post before this year ends. :-) Anyway, you may know that I have developed a MSBUILD task dll for deployment of SQLCLR assemblies. I also created some templates for use from with Visual Studio 2005, the SQLCLRProject. ...

Analysis Server 90, SQL Server 2005

ipramod - 26 Dec 2005 12:18 PM - 1 message

Hi, I have installed SQL Server 2005. Now, in the system performance viewer I can see some new performance counters added. But I am not able to see any performance counter related to "Anlysis Server 90". Is "Anlysis Server 90" is the new performance object and how to get ...

Unable to Connect to SQL 2005 from SQL 2003 Client Tools

Richard Blackwell - 26 Dec 2005 12:00 PM - 4 messages

When attempting to connect to a 2005 db at my ISP from 2003 client tool i get: "to connect to this server you must use sql server management studio or sql server management objects". I can find NO references to this error ...

Synchronising/replicating access with sql server

John - 25 Dec 2005 3:10 PM - 2 messages

Hi Is there a way to synchronise/replicate an access db with sql server 2000 db, short of writing the code oneself? Thanks Regards ...

Earn money Online - without risk!

Earn money Online - without risk! - 25 Dec 2005 2:46 AM - 1 message

Earn money Online - without risk! For all people, who can utilize money. Are you on the search for a lucrative source of income? Would you like to work of at home out of, without yourself you someone makes directions? Would you yourself like to ...

Synchronising with remote server

John - 25 Dec 2005 1:01 AM - 2 messages

Hi We have an internal ms access database which we need to synchronise with our website with sql server 2005 backend which is hosted on a public host. My question is; is there a way to keep the two databases synchronised using the ...