SQL Server Tools

SQL Server Management Studio Express allows you to script a table or a view, etc.; however I've not found a way to generate a script for the entire database schema. What I want is a script that will reconstruct the entire ...

I am using SQL Query Analyzer Version SQL 8.00.760. I have a stored procedure that I built that creates a temporary table inside of it.  When I open the stored procedure for editing, either by right-clicking the stored procedure in the object browser and choosing edit ...

Hi, I just came accros this problem this week. The RTM version of SQL Server 2005 Management Studio is not able to display a NULL value'd content of a nullable UDT in the "Result to GRID" Grid control! If I do have choosen "Result to GRID" and when I do a "select * from ...

I go to Tools -> Options -> Environment -> General and simply check "Hide system objects in object explorer". After pressing OK, it tells me the changes will take effect after Mgmt Studio is restarted. So I close it and fire it up again. And the system ...

I'm trying to implement ASP.NET 2.0 Role Management on an SQL Server 2000 DB. It worked fine on my development server, but when deploying to my test server my login dialog (using ASP.Net Login Control) fails with the following ...

If I create an HTTP SOAP endpoint in SQL Server 2005, as in my post of 04/03, then at what HTTP address can the endpoint be addressed?  In other words, how do you test the enpoint?  Does it look like a SOAP Web ...

I have an issue with trying to install SQL 2005 standard on my XP machine. I get an .hta file that is not readable and when I btpass that I get a pop-up message: please go to the control panel to install and configure system components. ...

i have a DB with DB users that are mapped to server logins after backing the databasr and restoring on other server (with the same logins defined) the logins are not mapped to the sql user wanting to do this from the security folder in enterprise manager, pressing ...

The Reporting Services Login dialog box appears repeatedly when you deploy a report on a remote computer by using Visual Studio 2005 We have SQL Server 2005 Reporting Service installed on Windows Server 2003 Enterpr. Edition SP1. the prompt look like the known bug in the old sql reporting service see ...

I'm currently using a new workstation and need to manage some databases on my ISPs SQL 2000 server. I've tried installing SSMSEE, but it won't install since I don't have SQL2005 (or any SQL server) installed on this machine. ...

Hi all, I was wondering if it would make sense for Microsoft to unbundle SQLCMD from SQL Server 2005. The tool is a basically a command line *client*, right? I have a machine that I would love to put SQLCMD on to do remote admin ...

Hello Friends, These are the methods I have used to migrate my database tables (I don't want data): 1. Generate SQL Query by Right Click on Database and Generate Query from SQL Server 2000 (selecting all options i.e. All Tables, Views etc...). Run that ...

I'm trying to add more than one view to my database in a script. While the view in my scripts are different than the example below, it illustrates the problem. Essentially, when I try to add more than one view, I'm getting a parsing error on the word "GO". The script works OK in SQL 2000 Query Analyzer but fails in Management Studio. I've installed the SQL 2005 Service Pack 1 CTP on my Windows XP SP2 workstation. When I run only the top or bottom portion of the view, the respective view script parses and runs. ...

I've been trying to get to the MSDN Product Feedback Center to report a bug in SQL Server 2005 Management Studio. I'm getting an Error when I try to reach the site - msdn.microsoft.com/feedback - Is it available? ...

hi all, i m new on Sql and i have a project related to C# and Sql. i have to do a project which must work on LAN, and there must be only one database file on main computer(Server Computer) and other ...

I'm new to SQL Server 2005.  I was attempting to run the SQL described in the help file section called 'CREATE ENDPOINT (Transact-SQL) '.   Here is that SQL: ------------------------------- CREATE ENDPOINT sql_endpoint STATE = STARTED AS HTTP(    PATH = '/sql', ...

All, I'm trying to put in a facility for the remote management of SQL2000 databases using the 2004 version of Web Data Administrator as provided by Microsoft. This is currently running on an IIS6 server in a virtual root ...

Is there a way to set view attributes in the View Designer?  This is a awesome tool but it seems to fall short when specifying the options.  For example, if you want to create a view with the CHECK OPTION, can you do this ...

Hi, SQL Server 2005 x64 I have a weird problem when analysing a trace log with DTA. The problem is that the trace log include syntax error for datetime!!! Ex. A date time parameter would appear like this in the trace window. ...