Dear Everybody: I try to run SQL Server Profiler, It always pop up this error window: "Only TrueType fonts are supported. There is not a TrueType font. How to solve this problem? Thanks for your help Obason ...more >>

I am using VB.Net in VS2005 against SQL2005. I am writing an UPDATE query and getting an error on my date/time fields. An example of my query string is - DOB = #3/12/1949 12:00:00 AM" I get the error - "Incorrect syntax nar '12' The way I generate the above string is from a data table and I...more >>

Hi, Does anyone know if there is a list of command switches available for SQL Server Service Manager sqlmangr.exe? Thanks Colin ...more >>

I need to compare two tables from external sources. The problem is that they don't share a single identifying field, so I'm creating a new one. In doing so, I'm using this formula: ISNULL(Field1, N' ') + ISNULL(Field2, N' ') + ISNULL(Field3, N' ') + ..... + ISNULL(Field15, N' ') Field2 and Fi...more >>

Hi I am pretty new to SQL Server 2005 and I have already learn so much. I had a quick question. Where is the "Assisted Editor" for stored Procedures. I can edit them on my own but there are other on my team who have never even hear of stored procedures and it would be helpful to them. If you...more >>

I can access all the tools of SQLServer2000 desktop when I'm logged on to my pc with administrator privileges, but if I'm logged on with power user and debugger user privileges the client software refuses to connect me. I prefer to use my pc without administrator privileges. Does anyone know...more >>

I can't find the syntax to do this in BOL, but surely there's a way. For a given database, I'd like to execute a query which would return to me a list of all tables in the database, and the number of rows currently in each. Any help appreciated. ...more >>

Hi All Reading the posts with great enthusiasm. I am just starting on the journey of SQL. The question: I have a developers version of sqlserver 2000 boxed with my visual studio 2003. Should I install that and embark on my journey or download and install the 180 day trial version of sqls...more >>

All, I appreciate everyone's patience, as you can tell, I really am new at this. Let me try phrasing my question a different way: What properies of a table prevent data from being returned by a SELECT statement in a stored procedure, when the same select statement executed from inside the S...more >>

Query returns no data rows even though the table contains data. The query text, scripted table, and data are shown below. What could keep the query from returning the two data rows that exist in the table? Thanks, Keith THIS IS THE QUERY: ALTER PROCEDURE [dbo].[GetUsers] AS SELECT * ...more >>

Hi After many years using InterBase where I had generators to generate unique sequence numbers, I am now using SQLServer 2005 for the first time. I want to generate a system-wide, unique, sequential Int32 value that I can call in a single command from C# .NET 2.0 Do I have to use a sing...more >>

In a database with two tables, both containing data, SELECT queries against one table returns data rows as expected, while queries against other table return only column headers and no data rows? The first table was created manually using SQL Server Management Studio, the second table was crea...more >>

Hi--I need to script a simple SQL Server 2005 database, structure and data. The database has data only; no stored procedures or the like. I'm using the full (Developer) edition of SQL Server 2005. Does Management Studio have a command that will do what I need? The Generate Scripts Wizard on...more >>

is it possible to have a column have an unique constraint but still allow nulls? ...more >>