SQL Newsgroups: Microsoft SQL Server Administration

License Installation Question

DrTompkins - 15 Jul 2006 9:23 PM - 3 messages

We have purchased SQL Svr Standard Edtn (1) and SQL CAL 2005 English OLP NL User CAL (10). I have Authorization Number and License Reference Numbers (the Keys) I cannot find the KeyHole. How can I install the licenses on my 2003 server? ...

Backup strategy

giminera - 15 Jul 2006 12:23 PM - 4 messages

I have to build a backup method for my factory. I have sql server 2000 and I have to save a DB that is used from 8.00 to 20.00. Now I have a complete backup that run every night and a differential at ...

Upgrade from sql 2005 express

andy - 15 Jul 2006 11:00 AM - 2 messages

I have a XP development machine with sql express on it. I would like to install sql 2005 developer on this machine. When I run setup it tells me I need to run the setup from a command line. I can't find any info on doing this. ...

Consistency Errors - Large Table

simone_maynard - 15 Jul 2006 1:51 AM - 3 messages

I have a large table with 10 million records. It has only one clustered index (0% fill factor) Total size of database is about 15 GB. I am always running into consistency errors. It's frustating. Every two days or so I run into a problem. ...

Backup/Restore vs Detach/Attach 2000 Databases to 2005

Peter - 15 Jul 2006 1:38 AM - 3 messages

I'm trying to see the differences between Backup/Restore and Attach/Detach. I backup and detach a database from SQL Server 2000 SP3 and then attach and restore it to SQL Server 2005 SP1. The differences I noticed are: ...

Restore backup into another database

GeorgeJ - 14 Jul 2006 11:33 PM - 2 messages

Hello everybody! I need to restore a database backup into another database. (i.e. to restore the backup of database A into database B). Is it possible with SQL Server 2000? Thanks! ...

Delete log of DataBase

Matías - 14 Jul 2006 11:13 PM - 5 messages

I have a DB in SQL Server who has very big log 60gb and I want to delete, how can I do it that??? Thanks in advance ...

table variables

Alex - 14 Jul 2006 11:06 PM - 4 messages

Hi friends, I ran across a statement that table variables are purely in-memory objects. Is it true? I thought that behind the scenes sql server holds table variables data in tempdb under some circumstances. Thanks for any insight Alex ...

Root Directory....

Lowry Smith - 14 Jul 2006 9:35 PM - 2 messages

How to read the root directory programatically. SQL2K. Thank you, Smith ...

Efficient Date Query?

James - 14 Jul 2006 9:04 PM - 2 messages

Have data stored in two separate fields (Start_Date and End_Date). i.e.: ID Start_Date End_Date 1 5/5/2006 7/8/2006 ...

Create DB from Backup

.seb - 14 Jul 2006 8:48 PM - 2 messages

Hi all, is there an easy way to create a Data Base from a Backup file? I've tried creating the data base and then trying to restore the prevous backed up data base but I get some errors like "Directory lookup for the file (the mdf file) failed with the operating system error 3 (The system cannot find the specified path)" ...

Document Management - SQL Server 2005

Gene - 14 Jul 2006 8:31 PM - 5 messages

I am researching a server for ProSystem fx Document Management. System requirements break down the servers 40+ GB drive like this: c:\ system = 10 GB d:\ log files = 10 GB e:\SQL DB = 15 GB Would c, d and e be one RAID 5 array? ...

How to get the record created date?

tcw - 14 Jul 2006 8:15 PM - 10 messages

How do I delete rows that are older than 180 days if the table does not contain a column of timestamp? The following statement works fine if parameter startdate is known: DELETE From MyTable Where DATEDIFF (day, startdate, GETDATE()) > 180 ...

Simple Question aobut 2005 memusage

sullins602 - 14 Jul 2006 7:59 PM - 2 messages

Does anyone know what the equivalent of the 'DBCC MEMUSAGE' command is in 2005? ...

Red-Gate SQL Log Explorer

Jason_Williams - 14 Jul 2006 7:16 PM - 4 messages

Does anyone happen to know if the folks at Red-Gate used a public SDK to create the log explorer, or did they fork over money to microsoft to get a ISV licensed SDK? I'm looking into making a similar product that would be open source, ...

Proc for Backup

Greg - 14 Jul 2006 6:29 PM - 7 messages

Hello: Does anyone have a good proc that will do a full backup of database and remove old backups after "x" days? I have one currently, but it sometimes misses a database (I assume the logic or a bug in SQL Sever)? ...

How to get the missing dates

Michael - 14 Jul 2006 5:43 PM - 2 messages

Hi Everyone, I was wondering how I could get the missing dates. I have the following table: --Attendance-- ClientId AttendDate --Patients-- PatientId LastName FirstName ect... This table holds dates that our client has been in our office. But I need to ...

Timeout error msg 2147217871 during query(s)

WB - 14 Jul 2006 5:38 PM - 2 messages

My app is running VB6.0 on the front end and SQL Server 2k replicated from the corporate office to multiple locations. The corporate office is running a dual processor server with 512 megs of RAM. Each remote location is ...

Creating messages from SQL to the Windows Event Viewer app log

Marco Shaw - 14 Jul 2006 5:38 PM - 3 messages

(For MS SQL 2000... Please don't suggest anything using VB or .NET. I need something either somehow built-in with SQL 2000 or using VBscript.) Anyone know of a way to create a test message somehow through MS SQL so that ...

q; a trigger code

JIM.H. - 14 Jul 2006 4:57 PM - 8 messages

I have table T1 and I am trying to extract some date from T1 table based on inserts, updates and deletes. The destination table T2 has three fields F1, F2, F3, so I need something like Insert into T2 (F1, F2, F3) ...

Question for T-SQL Gurus

Dave - 14 Jul 2006 4:05 PM - 10 messages

I have a table that relates emails together. I would like to leverage this information to create a rollup key that can be used to identify the entire group. Some groups will have one email some will have many. ...

SQL query help

HP - 14 Jul 2006 3:30 PM - 9 messages

Below is my view which returns 70,000 + records. It takes like a minute or more sometimes. How can I make it faster. With time the number of rows are going to increase and the query will take even longer. Please help how I can ...

If exists for temp table

DXC - 14 Jul 2006 2:58 PM - 4 messages

What is the syntax to drop a temporary table if exists ? I want to drop a temp table ##temptable if exist before I try to create it. Thanks. ...

Restore sql server database

giminera - 14 Jul 2006 2:45 PM - 2 messages

I did one complete backup, and two transaction log backups. The first of log backups is corrupt. So I have to make a restore with the complete backup and only the second log backup. Is it possible? Thanks. ...

SQL Server 2005 - Reenter Passwords

Cgal - 14 Jul 2006 2:29 PM - 3 messages

When I connect to a SQL Server 2005 database engine server in SSMS I connect with SQL Server authentication and I specify that I want to save the password. I must reenter the password occasionally and I am wondering why. ...

Phantom backup job failure

Rob - 14 Jul 2006 2:22 PM - 4 messages

Hi, I have created a DB maintenance plan to backup one user DB, which is retained for a day, thereby instructing SQL Server to delete any backup files older than a day. The resulting job from this maintenance plan runs fine, as seen from its ...

Inherited A Very Large Database Need Advice

TMan - 14 Jul 2006 1:55 PM - 5 messages

I inherited a very large database on SQL Server 2000 EE Service Pack Four. The OS is Windows 2003 EE. The server has a backend SAN. The database is 570 GB and the underlying structure is one data file and one log file. This ...

Re: SQL Server 2005 Performance

Port 119 - 14 Jul 2006 12:24 PM - 2 messages

FYI - If this is a web application then most likely you are using temp tables alot. SQL 2005 uses these more and the temp table should be put on a separate disk or better raid 0. Regards, Tom Bizannes Microsoft Certified Professional ...

Log file for database is full

JosÃ© JÃºlio Duarte - 14 Jul 2006 9:07 AM - 6 messages

hello when i execute this command: DBCC DBREINDEX ('dbo.OV_PM_LPolGroupAssignment', PK_OV_PM_LPolGroupAssignment) GO give me this error: Server: Msg 9002, Level 17, State 6, Line 1 The log file for database 'openview' is full. Back up the transaction log for the database to free up some log space. ...

INSTEAD OF TRIGGERS DO NOT SUPPORT DIRECT RECURSION

Dimitris Ioannou - 14 Jul 2006 9:02 AM - 3 messages

I HAVE A DATABASE IN SQL 2000 WITH SOME STORED PROCEDURES AND SOME TRIGGERS IN VIEWS AND IN TABLES. ALL CODE FUNCTION WELL IN SQL2000 BUT WHEN I TRY TO MIGRATE THIS DATABASE TO SQL2005 WHEN I RUN A PROCEDURE I GOT THE ERROR ...

how to replace #$D#$A with enter key in query analyzer

kei - 14 Jul 2006 8:31 AM - 13 messages

as captioned, how to replace #$D#$A in sql statement with enter key in query analyzer? I know in UltraEdit, we can replace using ^p, but how to do it in SQL analyzer? thx! ...

Converting varchar to date

jjaggii - 14 Jul 2006 8:08 AM - 4 messages

Hi Not being a coder I have no idea how to do this and existing posts dont really help. I have a table called 'Incoming' and a column called dateofbirth. The format of the column is varchar. The values in the dateof birth column ...

Is it possible to make INSERT/UPDATE operation in SSIS?

Igor A. Chechet - 14 Jul 2006 8:01 AM - 4 messages

Hi! I use SSIS to insert some data from text sources to SQL server 2005. I use check constraints option. Is it possible if iserted record has the same primary key as existing record in table to replace existing record? How to ...

Performance Change In 1 Day, How Can I See, What???

Åženol Akbulak - 14 Jul 2006 7:15 AM - 4 messages

Hi, We have an application runs on SQL Server 2000 online (win 2000). Yesterday, I saw that an T-SQL which runs in 3 seconds, is running now in 30 seconds (After 1 day). Then I saw that windows update installed patches and restart ...

Multiple files import

jakub - 14 Jul 2006 7:02 AM - 3 messages

Hi, I would like to make some DTS package that loads into one table all txt files that are located in one directory (but I don't know how to do it). Any help appreciated. br, jakub ...

Problems with collation

milan.letic - 14 Jul 2006 6:26 AM - 2 messages

Hi, I have one problem with collation and asp.net 2.0 security. I wrote about it here: [link] Can you please look and propose solution. ...

Migrating DB2 to SQL Server 2005

renil - 14 Jul 2006 5:02 AM - 2 messages

Hi, I want to migrate my data from IBM DB2 to SQL Server 2005. What drivers are needed to do the same? Where will I get all those drivers. Could any one help me? Is there any other ways to migrate data from DB2? ...

Object owner in SQL Server 2005

philt - 14 Jul 2006 4:38 AM - 5 messages

I understand about the new schema namespace feature in SQL 2005 but I'm confused on the actual object owner. Where do I see\find the actual object owner. thanks in advance, Cheers ...

How to do row level locking in SQL server 2005?

Connie - 14 Jul 2006 4:25 AM - 4 messages

Hi, For example, there are 2 users connecting to the same table and want to update the different rows. They are requested to use the row level locking. Pls advise and provide the example of sql statement or sample code. ...

Database Version Logging

kwangsa - 14 Jul 2006 2:22 AM - 8 messages

Hi i just planning to creating a database version logging, where the idea is this application running every night give me detail about table schema change , new sproc , alter/drop sproc and other database schema changes. One of difficulty that i facing right now is how to get the username ...

Subquery question

Mounilk - 14 Jul 2006 1:37 AM - 6 messages

In my select list, I have a subquery to get a field. It is something like this: ( SELECT X.Field3 FROM ( SELECT Table1.ID AS Field1, ...

MVP/GURU ADVICE NEEDED!!! Can't Identify Blockers.

DBA Land - 14 Jul 2006 12:21 AM - 19 messages

Greetings and thanks for Reading my post. Our company recently rolled out an application that is mission critical. It was supposedly best product in our industry but have had nothing but problems which I have mostly solved. Here is the background - due to security flaws in the application (users ...

Explanation of stored procdure that is working fine

Steve1445 - 14 Jul 2006 12:01 AM - 3 messages

I have an autoID store procedure that I am sure most anyone but me can understand. I need an explanation of what it's doing at each point as it runs. It's not that it is not working correctly, it's just I need to ...

CLR out of memory

Abe - 13 Jul 2006 10:30 PM - 3 messages

I've got a CLR function that runs fine on my workstation running SQL Server Express; however, it throws OOM exceptions on the full SQL Server 2005. The function is very simple: it takes an XML file and a stylesheet, ...

Exporting Binary Data from MSSQL to MySQL

datenisis - 13 Jul 2006 9:15 PM - 2 messages

I have a MSSQL table with Primary Keys, Company_Id, set as a binary value. I used the dts Transform Data Task and to create a new table in MySQL. The default create code comes up with: CREATE TABLE `New Table` ( ...

SQL MAIL IN A DMZ

jcard71 - 13 Jul 2006 8:09 PM - 6 messages

Hi, We have a SQL server in our DMZ that I need to get SQL mail working, but our security group won't allow us to connect to an exchange server so we're stuck here... We have a sqlagent mailbox inside, but what do we do to connect to it or has ...

@@Version not updating

sullins602 - 13 Jul 2006 6:21 PM - 4 messages

Greetings, I recently installed Service Pack 4 on SQL 2000. The install went smooth with no errors and a message at the end stating the install completed successfully. I rebooted the server (Windows Server '03) and tried to check the @@Version global variable but it still lists only ...

Can't Delete Job

Greg - 13 Jul 2006 6:01 PM - 5 messages

Hello: I've got an old job I am trying to delete from my SQL Server 2005. Everytime I try to delete this, i get the following error: The DELETE statement conflicted with the REFERENCE constraint "FK_subplan_job_id". The conflict occred in the database "msdb", table ...

Querying a set of results

John Steen - 13 Jul 2006 5:53 PM - 4 messages

I have two tables (table1 and table2). Each has a user_id column in common, but all other columns are unique to each table. I need a query that will return the password from table1 for all of the users (user_id values) ...

Re: Error in Maintenance Plan (one of database)

Tracy McKibben - 13 Jul 2006 5:13 PM - 2 messages

Tracy McKibben wrote: After re-reading this, I should clarify. I wasn't attacking you, my apologies if it looks that way. Those maintenance plan wizards frustrate me greatly, because they attempt to gloss over what are some ...

DB restore error to new server

Bob - 13 Jul 2006 5:10 PM - 10 messages

Hi, We have just built a new Windows 2003 Std Ed, SP1 server with SQL Server 2005 no SP. We are attempting to restore the databases from an old server to this new one, however after the restore process gets to 100% we recive the ...

Hardware spec

Robbie Niblock - 13 Jul 2006 4:31 PM - 11 messages

Hi We are in the process of going live on two SQL applications. I am evaluating hardware requirements and would like to see if I am on the right track. 2 SQL apps. There will be about 15 users on both and down the line we will ...

Linked Server Problems from SQL2005

Terry - 13 Jul 2006 3:51 PM - 9 messages

When I run linked server queries from SQL2005 it fails. Query Example : SELECT * FROM [servername].master.dbo.sysobjects Error: OLE DB provider "SQLNCLI" for linked server " servername" returned message "Communication link failure". Msg 10054, Level 16, State 1, Line 0 ...

Error in Maintenance Plan (one of database)

JosÃ© JÃºlio Duarte - 13 Jul 2006 3:42 PM - 4 messages

Hello When i execute the Maintenance Plan, Database Maintenance Plan (Optimization): (Check) Remove unused space from database files Shrink database when it grows beyonds: 50 MB Amount of free space to remain after shrink: 10 % of data space ...

Index Locking Operation Questiong

Mike M - 13 Jul 2006 3:40 PM - 3 messages

Given a table with a clustered index and several other nonclustered indexes which references the column defined in the clustered index, what type of locks should I expect to be placed on all of nonclustered index? For example, create table tblTest ...

Moving database...

BenUK - 13 Jul 2006 3:16 PM - 3 messages

Hi all, We have 2 databases on 2 servers... ...database 1 is a typical oltp database, database 2 is used for olap queries and a source for msas. Database 1 is on an old server which is part of an old domain, database 2 is ...

Database Size

Steve - 13 Jul 2006 1:52 PM - 8 messages

If I'm creating a db from an inport, and I know it will be large (400 gig), is it faster to create the DB that size, or create a 1 gig DB and let it auto grow by 1 gig at a time when it needs it during the import? ...

New to SQL 2005, need a little help

bdhenderson - 13 Jul 2006 1:22 PM - 4 messages

I come from a Sys Admin background so excuse my questions if their simple in nature. Anyways we purchase an e-mail system at our company that uses SQL server as it's database. In the documentation, it states I need to ...

Error Handling not workinh after select a bad table

sevlar - 13 Jul 2006 1:20 PM - 2 messages

Hi guys, I have a SP that is executing a simple task, and I´m forcing an error, but the SQL Server is not catching the error, please help me. The code is: insert into table1 select * from table2_bad ...

What versions am I running

Greg Smith - 13 Jul 2006 12:08 PM - 3 messages

I am running SQL Server 2000 on a system that is also running Backup Exec tape backup software. Backup Exec is running it's own instantiation of SQL server. Our security people tell me that I have a security hole on the ...

q; stored procedure lowest priority

JIM.H. - 13 Jul 2006 12:03 PM - 4 messages

Hello, I have a long stored procedure that performs some inserts and updates on the table that users are accessing through a user interface. We this stored procedure runs users experience slowness, is there any way I can get the ...

Error in Maintenance Plan (tempdb)

JosÃ© JÃºlio Duarte - 13 Jul 2006 9:31 AM - 2 messages

Hello Give this error in Maintenance Plan: 8] Database openview: Removing unused space from the database files (if database size is more than 50 MB). Reducing free space to 10 percent of data...[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 9002: ...

xp_cmdshell with bcp failing with "access denied"

Richard - 13 Jul 2006 3:26 AM - 5 messages

Has anyone ran into the problem of receiving an "access denied" error when using bcp via xp_cmdshell? SQL Server 2005 SQL Server service account is in administrators group on machine where bcp file is located. Logging into SQL Server as administrator from a remote machine via osql to ...

sql server2005 performance

Billie - 13 Jul 2006 2:44 AM - 6 messages

hi... i have just migrate from Sql server 7 to sql server 2005, but i have performance issue here. while loading database it takes 2-3 minutes or while click Save/Confirm "Command button" it also takes 2-3 minutes.. ...

Commit and Rollback samples

Jason Huang - 13 Jul 2006 2:27 AM - 2 messages

Hi, In my SQL Server 2000, I would like to test the COMMIT and ROLLBACK. Would some give me some suggestions? Thanks for help. Jason ...

Server is invisible to others

Alan T - 13 Jul 2006 1:43 AM - 4 messages

I got a problem of my server instance which is not visible to other person's SQL Server. They cannot create a new server by right click the SQL Server Group to select "New Server Registration...". My SQL Server does not appear in the list. ...

Rebuilding indexes nightly bad?

davconts - 13 Jul 2006 12:02 AM - 14 messages

Hey all, My company currently rebuilds the database indexes nightly. We haven't really done an analysis on what fill factors might be good for our indexes, and use a stock value of 95 when rebuilding. Our application does majority of reads when using the database, ...

full-text search : noun & verb variatrions

News User - 13 Jul 2006 12:00 AM - 4 messages

My full-text search works fine and it returns correct results, including records that contain the variation of the keywords. I bind the result to a gridview (ASP.NET 2.0), and programatically replace the matched keywords with a highlighted background etc. ...

Memory usage

Himanshu - 12 Jul 2006 11:54 PM - 8 messages

We have about 40 SQL Servers in our environment, and none of them use 2 GB of RAM - in fact they all use between 1.6 and 1.7 GB. Our configuration option is set to dynamically use memory - and our ...

q; how to improve this transaction

JIM.H. - 12 Jul 2006 11:19 PM - 3 messages

Hello, I have four different transactions such as below and I do one insert and one update in each transaction and it seem it is slow and creates deadlock with the user interface. These transactions are performed against the tables that users are accessing ...

read *.mdf files

Newbie - 12 Jul 2006 10:18 PM - 5 messages

Hello, I am new for MSDE. Our ISA2004 server has report in *.mdf and *.ldf format. We don't have SQL server. I installed MSDE on my workstation. Is there any step-by-step instruction to show me, how to create Access ...

Db Backup

Omran Abdurrahman - 12 Jul 2006 9:25 PM - 2 messages

I need to creat SQL Database backup that I can have a user with no SQL server installed on his/her PC to be able to execute the Backup Job how can I use in exe. thanks, Omran ...

Cannot create Recurring backup

Rob - 12 Jul 2006 8:39 PM - 3 messages

I am not able to create a recurring backup job on sql2005. There is no schedule option when you right click on database then tasks-->backup, also when I try to do it thru maintenance plan I am not able to see my databases. ...

Existing MSDE with SQL2005 installation

mecn - 12 Jul 2006 8:25 PM - 2 messages

Hi, I have a box woth MSDE installed. I need to install sql2005. My question is that 1. Do i have to uninstall MSDE first or I could upgrade MSDE to SQL2005 server? 2. Can I have both MSDE and SQL2005 existed in the same box? ...

SQL2005 install over standard server with microsoft desktop engineen installed

mecn - 12 Jul 2006 8:14 PM - 2 messages

Hi, I have the standard sql server box with microsofe desktop engineen installed. Is it ok to install sql2005 without any probblem? Thnaks ...

SQL & MSDE

Ed - 12 Jul 2006 7:43 PM - 2 messages

I have a server running a MSDE database. I administer the database using SQL 2000 Enterprise manager from another server (I am fully licensed to have the sql Enterprise Manager). I am removing the server running sql 2000 but want ...

q; sp_executesql and speed

JIM.H. - 12 Jul 2006 7:13 PM - 2 messages

Hello, I am using sp_executesql this to pass parameter to sql string and I am seeing deadlock between sp_prepexec which does UPDATE with another UPDATE done by another process. When it comes to speed and deadlock, would you recomand not using sp_executesql? ...

SQL 2005 - Dedicated server?

Gene - 12 Jul 2006 6:15 PM - 3 messages

Hi all, I've searched the threads here to no avail and have a very simple question. Is SQL typically installed on a dedicated server? Pro's and con's? Thoughts? Could you please pass on any relevant resources? This is new to me and I'm ...

Changing SA Password in SQL 2005

steve - 12 Jul 2006 6:13 PM - 2 messages

Hello, All Is there a way to change the sa password in SQL 2005 without knowing the existing password? I tried everything I can find online to change the password but nothing works. This is on my test server so I am opened to anything. ...

changing the sa password in SQL 2005

steve - 12 Jul 2006 6:11 PM - 4 messages

Hello, All Is there a way to change the sa password in SQL 2005 without knowing the existing password? I tried everything I can find online to change the password but nothing works. This is on my test server so I am opened to anything. ...

"Database diagram support object cannot be installed...

Dan - 12 Jul 2006 5:11 PM - 3 messages

....because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects. " ...

SQL CD with SP4

Tark Siala - 12 Jul 2006 5:02 PM - 3 messages

hi i have SQL Server 2000 Enterprise on CD, and SP4 of SQL Server. how i can make new CD of SQL contains SQL Server With SP4, i mean when i install SQL i install SQL with SP4 Direct. ...

Change DB owner

Dan - 12 Jul 2006 4:46 PM - 2 messages

How do I change the owner of a database in SQL Server 2005? ...

q; Tracing the deadlock

JIM.H. - 12 Jul 2006 4:34 PM - 2 messages

Hi, I need to trace deadlock, one of article was mentioning â€œQL Server Profiler's Create Trace Wizard to run the "Identify The Cause of a Deadlock" for SQL Server 7.0, is there any way I can do this in Sql Server 2000? ...

Logic Question

wmureports - 12 Jul 2006 3:55 PM - 5 messages

Ok so I have a little problem. I dont want code or anything I just want a little help with the logical steps to take to complete the process. Little background, we have students who come and take 10 courses to get ...

q; using RAISERROR

JIM.H. - 12 Jul 2006 3:06 PM - 3 messages

In my Windows application I use sqlCmd.ExecuteNonQuery() to execute the stored procedure, In case of an error in the stored procedure I need to return an exception to application, will RAISERROR in stored procedure accomplish that? ...

Connection timeout when using transactions

Natan Vivo - 12 Jul 2006 3:05 PM - 8 messages

I'm getting a timeout error while trying to select data from SQL server 2005 after opening a transaction in asn asp.net application. It goes like this: SqlConnection conn1 = new SqlConnection(...); conn1.Open(); SqlTransaction trans = conn1.Open(); // do some inserts and updates using the transaction ...

Date-time unsupported in subquery?

Ryan - 12 Jul 2006 2:48 PM - 7 messages

I have a query that returns 2 fields, a date-time field and a Count(*) field. Basically it tells me how many people exist for a specific date. I want to use this as a subquery and test for the earliest date that the ...

Timeout and DeadLock in SqlDataAdapter.Fill method

Avinash - 12 Jul 2006 1:50 PM - 2 messages

Hello, I have following GetDataTable method wich will return a DataTable object from given command object. This is working fine when amount of data is not too much. In case of large data some ting like 60-70 thousand records, the control enters in ...

Migrating Structure of DataBase: How? Tools? Scripts?

Pieter - 12 Jul 2006 1:01 PM - 7 messages

Hi, I have a database (version 1), and for version 2 a lot of things will have to be changed, for isntance: - Change DataTypes of columns (char-columns to varchar, int to tinyint, ....). - Change names of existing tables and existing columns. ...

q; exit stored procedure

JIM.H. - 12 Jul 2006 11:44 AM - 5 messages

Hello I have three stored procedures Sp1 calls Sp2 and Sp2 calls Sp3 as follows: Exec Sp1 Inserts, updates Exec Sp2 Inserts, upadtes Exec Sp3 ...

SQL Server Port

Double_B - 12 Jul 2006 11:42 AM - 6 messages

I have access to the default instance of a SQL Server ..... I have access to the QA only .. by reading the registry through the QA I get to knw that there are additional 4 more instances on the Server ..... is is possible to get the port on which they are listening using the QA ...

There must be a way

alamb200 - 12 Jul 2006 10:34 AM - 7 messages

Hi I am new to using SQL and have installed SQL 2000 sp3a on my xp machine and set up a tech support database. This works great I have web access everything I wanted, except for one tiny detail some of the solutions in the database are quite lengthy and ...

Authentication methode

Arjan - 12 Jul 2006 8:34 AM - 2 messages

Is it possble to change the way users are authenticated within a SQL Server 2005 installation? And if so ho can it be done? I want to go from a Windows Authentication to Windows Authentication/SQL Server Athentication.. TIA, Arjan. ...

SQL Server 2005 Performance

masri999 - 12 Jul 2006 8:32 AM - 3 messages

Hello, I have installed SQL Server 2005 and applied SP1 and hotfixes . I have restored a SQL 2000 databse onto SQL 2005 . Note: SQL Server 2000 and SQL Server 2005 are on the same box . Web Server is on a different box. ...

SQL Server and Unicode characters in char/varchar

Jan Kostrhun - 12 Jul 2006 7:46 AM - 2 messages

I am newbie in MS SQL Server. I was asked to migrate our database from Oracle to MS SQL Server. We need store Unicode characters into the database, but current database script contains tables with char/varchar columns. - Is it possible to set up database to store Unicode characters into ...

sp_send_dbmail memory error?

HSPoulsen - 12 Jul 2006 7:33 AM - 2 messages

We're using sp_send_dbmail on SQL Server 2005 RTM, and it works, unless we try to send 10 MB emails. We have liftet the (very low) limit of 1,000,000 bytes to 10 MB. We can send emails as long as they are below approx 2 MB. ...

full backup database files includes transaction log?

lovexueer - 12 Jul 2006 7:31 AM - 9 messages

when I complete full database backup , I want to know this full backup file includes transanction log ? ...

resend - transfer database to a new server

Bill Brehm - 12 Jul 2006 5:48 AM - 4 messages

Sorry, I'm sending this again because I think it must be buried under week old posts that no one will see. If I'm wrong please let me know. I was able to successfully back up all the databases like master, model, ...

How to let user use xp_cmdshell?

angi - 12 Jul 2006 4:32 AM - 10 messages

Hi I wonder to know Hot to let SQL Server user (not Admin role) use xp_cmdshell? Cause the execution response access denied. What should I do? Thanks! Angi ...

Phantom SPID within sp_who2

how to not lose positioning of 3 resultsets

remote sql server is the same as local in em

Deadlock (strange update deadlock)

SQLEXPRESS Newbie Question

date

Excel to SQL 2000

Querying Linked Database

Issue with Attaching database (MS SQL Server 2000)

Registry information

Compare sql (SQL DIFF)

osql permissions

Loading Data into SQL Server.

Device activation error problem, Index file missing

DBCC CheckCatalog Error on SQL 2005

Deadlock on different unique RIDs in SQL Server 2000 - how?

msde restore problem

What happens to data files during backup?

Create Login within a stored procedure

How to make SSIS 2005 work like DTS 2000?

DBCC CheckDB Repair Allow Data Loss

20 million rows taking too long to return

Unable to output to a temp table

Access to SQL Server Express

Help for Query

Size of Database restored

Radio Button

backup db

Valid SQL Server backup

q: deadlock victim

automatic script with SQL Server 2000

Strange Autogrowth Issue

How do I send a SQL Server Alert to Multiple Operators?

Windows 2000 / SQL Server issues

DTS Question ...

Is installing MS Outlook a security risk?

x64

Log File Management

table partitioning design question

Cannot shrink log file

Guest

Error in master.dbo.sysindexes

Faster Query

Check for Date

BCP using ODBC - problem with unique identifier

SQL Server 2005 Data Load

Advice needed

what is CmdExec???????????????

SQL Server Log file

SQL Server hardware specs

sql server 2005 - log shipping

Transaction Log backup question

Not able to reduce tempdb size

Severity 16 Errors - Miscellaneous User Error: Free disk space rea

Field overflow and Log grow

Virtual Server

SQL Server 2k Developer Edition

DB size issues

SQL Server Setup for the best performance question

Meta Data Services

Problema nell'update di un trigger

Performance and SQL 2005 - need some assistance

how to Allow Multiple access to data base over network

PP: New Features in SQL 2005

Backup continues to try to execute...

How to exclude from NTBACKUP SQL server?

Cannot restore

String or binary data would be truncated

sql server 2005 running ssis packages via a scheduled job