Hello, I am very new to SQL, so please go easy on me... I need to come up with a reporting scheme, and I am not sure what to do. Right now I pull information from SQL 2000 to Excel. I need to come up with something better, something automated. Can you please suggest some resources? Is there ...more >>

Hi everyone, I have been experiencing a problem that is locking up queries on some of my db's. We do a lot of record updating, deleting, and inserting with a good number of indexes and it appears as if occassionaly something will happen to the table that causes all queries that use the index...more >>

Okay, I'm confused. I am working with MSDE 1.0 (v 7.00) and MSDE 2000 (v 8.00) and the SCM utility. When I run the command "scm" I get a help screen with many of the different options available. For instance, if I were to type the command "scm -action 3" it will return an exit code to indica...more >>

hi i have this sql statement: USE myDB --begin tran t1 exec mySP 'parameters' --rollback tran t1 (info: i want to rollback the transaction because i just want to test the SP and see the execution plan) the execution plan with the two transaction lines commented differs completely from...more >>

When using SSIS and importing data from a view in ORACLE, the transformation does not pick up the precision on calculated columns from the Oracle view. The calculated columns in the view have precision applied to them via the CAST function. The data retrieved always comes back as a NUMERIC(...more >>

Hi all: I need to convince my customer to use SQL2005, but after google, it seem like most of the people say oracle is better than SQL server.....why.... I need your input please. Thanks JCVoon ...more >>

I'm trying to copy a database from my machine's SQLServer2005 to a production machine. I tried a restore from backup, which gave me an error that the on disk structure was 611 and the production machine supports 539. I've looked around and found similar problems, but those were all involving SQL...more >>

I've been developing an ASP.NET app using the default user and profile provider, which is SQLExpress. But to go live we are going to use SQLServer2005. I know I can use the ASPNET_REQSQL tool to prime SQL2005, which apparently just creates an ASPNETDB.MDF file. However, since I already have a lo...more >>

I've installed the Developer edition of SQL Server 2005. The sample databases were selected. When I loaded management studio, I don't see the AdventureWorks database. I did a search on the hard drive and nothing came up except something related to reporting in a templates folder. No MDF file...more >>

I am working on WinXP Pro & use SQL Server 2005 as the database server. Whenever I log into WinXP, I find that it takes considerable time to start (though the desktop appears in a jiffy). When I had a look at the processes running in my m/c by opening Task Manager & clicking the Processes tab, I...more >>

Hi! I have a batch file (.bat) that I need to execute inside my stored procedure (SQL 2000). I am trying to call that batch file using xp_cmdshell command. I am probably not using it the right way but I am trying to pass a path of the batch file into xp_cmdshell and it doesn't recognizes it ...more >>

Anyone have any suggestions for a good, user friendly, db management tool for SQL server? Needs to be able to create tables, insert records, modify columns, etc. Thanks, Jeremy ...more >>

I'm going to shut down the SQLServer services (SQL 2000) and do a cold backup of all the databases before performing some system upgrades. BOL doesn't have much information on cold backups. Is it an absolute requirement to back up both the data and log files in a cold backup, or are the data fi...more >>

Hi, I am not able to execute following command from computers other than the SQL server itself. select * from openrowset(bulk N'\\ImageServer\Model\Cam_05.dwg', SINGLE_BLOB) as doc I get following error message: Msg 4861, Level 16, State 1, Line 1 Cannot bulk load because th...more >>

I am a new user of SQL Server Express 2005 and I have a question. What do I need to do to ensure that the client can connect to the SQL Server 2005 Express database without specifying the port number - in other words just specify the instance (along with authentication mechanism.) We have mult...more >>

Hi, Big fan of this group, always get great help. Can anyone help me with this one? I have a table of test results and each time the result is written up, it writes the software level of the test machine along with the test result, the date and what was tested. Sample below as Test_Table ...more >>

Just wondering if using @table variables can be more optimal for performance or if one should use #tmp tables instead ? Thanks ...more >>

I have run into a strange problem with SQL Server 2000 (SP4). I am calling a fairly simple stored procedure that selects a set of data from one table based on several parameters passed in (combination of varchar and int). The problem is that everytime I execute this procedure, SQL server ret...more >>

Hi, I wish to know if it is possible and how can I create a view which represents values for each date during a period, knowing that I have only intermediate date. For a better comprehension, I gonna present you an example of what I'd like to do. Here is my table: Date value1 ...more >>

I have a table with this subset of fields: ID int (PK) ImportID int ImportDateTime datetime ImportUserID int (FK) ExportID int ExportDateTime datetime ExportUserID int ExportError bit ExportProblem varchar(50) etc... My question is, should I make two new tables with the Import and Exp...more >>

How to retrieve only column names using SQL Query in SQL 2000 and SQL 2005? Thank you, T. ...more >>

Hello, We've got a large vendor supplied SQL Server database in which almost all of the tables have GUIDs as primary keys. We are attempting to do some processing using our own in house procedures written in Access. In Access we link to tables in SQL Server via ODBC using .dsn files. The pr...more >>

We developed a DB for our customer using MS Access and upsized it to SQL Server. Our customer does daily back up of his DB and he asked me whether or not 'asdb' should be backed up as well. My question is: what is 'asdb' and whether or not it should be backed up. Any information or web links w...more >>

Hello all SQL experts! I have an interesting problem. Say I have two tables: TableA: UserID | LastName | FirstName | etc... 1 | Brown | Joe | etc... 2 | Johnson | Jack | etc... TableB: UserID | Image 1 | jasdfnaekrasdjasdf 1...more >>

Hi, I installed Visual Studio 2005 first, SQL Server 2005 Express was installed with VS2005. Than I installed SQL Server 2005 Developer Edition, but I cannot see Management Studio. How can I bring SQL Server 2005 Developer Edition up? I recall when installed, there is a message "Using com...more >>

what happends if an auto number (identity column) of datatype "int" goes beyond 2,147,483,647 ? Does user have to go for 64 bit in this instance? Posted Via Usenet.com Premium Usenet Newsgroup Services ---------------------------------------------------------- ** SPEED ** RETENTI...more >>

Dear In our company, we use sql server 2000 as the database server for softwares we produce. The problem is the way that we track the changes in database and control the changes which every developer makes in db (something like source safe that controls the code changes for our source codes) . ...more >>

Hi Can anybody tell me the sql query I need to find the following: I have two tables A and B. A is a parent to B. I need to find the rows in B which do not have a corresponding foreign key value to a row in A. Thanks in advance G ...more >>

Hi, I have a table with 30 columns. I want to insert a value of "0" into the columns I do not wish to do a insert into table (col1,col2,col3.....col3) values(0,0,0,0,0,0,......0) as it is a very painful process. One comma missing and it's going to hurt my eyes. Are there any shor...more >>

Hi Everyone, Most of our MS SQL Servers are still running on SQL 2000, but being I will soon be upgrading my workstation to Vista Business I'd like to install MS SQL 2005 Enterprise Manager to manage them all. When I tried to install MS SQL 2000 Enterprise Manager on Vista, it gave me a mess...more >>

Hello, I am a newbie to SQL Server and I wanted to ask the group if they could recommend some resources on how to do basic functions such as create a data dump. Thanks! ...more >>

Hello, I am looking for a way to determine the maximum number of consecutive days that each client has attended an event over a certain date range. (consecutive being key, and my problem). For example: Over the date range 1/1/06 - 12/31/06, Bob attended 42 consecutive, Jim 17 consecutive, Mar...more >>