Search results for query: *

I know this is not a technical question on SQL Server but as so many brains frequent this forum, I thought this is the place to get some answers. I administer the SQL server database of a company with sales under $100 million and our database size is less then 100G . As far as the databases...

I created a DTS package that copies a table from one database to another. It copies all the rows when I run it manually. If I run it as a scheduled job in MS SQL Server 2000, it does not copy all the rows. I created a exception file to trap the exception and it says...

I would like to update selected records in a Sql server table from an MS Excel spreadsheet using DTS. I tried to do this using Transfrom Data Task but it only lets me select data from excel. It does not let me write a update query. I could bring the data into a temp table in sql serer and...

I connect to a SQL Server database thru a .net web app. Now, if I go to Current Activity in EM I can see the details of the connection. However, EM show details of the process/connection even after I kill the application that connects to the database. It shows the status as "SLEEPING" and...

hi, I am a newbie in C# and I cannot figure this one out. I want to color the rows in a datagrid based on the value in the first column. How do I do that in C#? Thanks.

I want to store Unicode data of varying length in a column. The length could vary from anywhere from 100 bytes to 2000 bytes maybe more. Would I suffer a performance hit if I set the column lenght to maximum, that is 4000? Or, would be better to limit it to little over 2000 bytes? What are...

Can I use a nested IF condition in a Select query? I want to query different columns in the same table depending on what is the value of the given attribute. The psuedo code for the query looks like Select colA, colB, (If colC > 0 then colD Else (if ColE>0 then ColF Else (if ColG > 0...

For a few SQL Server databases that I maintain, I do a full backup daily on tape using VERITAS Backup Exec. By mistake the backup tape from July 2004 was applied to do the restore. Since the tape had the backup of all the databases on the production box, the restore got applied to all the...

I have links in Spread sheet1(MS Excel Spread sheet) that get data from cells in Spread sheet2. Data in Spread sheet1 gets updated after I open it. It basically ask me if I want to update all linked information and on a "yes" it gets the latest data. Is there a way I could update...

My query hits hits 7 tables via joins but lately it has started giving me a deadlock error and this problem came overnight. I have run the same query many times before but it never ran into a deadlock problem. I ran DBCC TRACEON (1204) to get more relevant information but it does not tell me...

Is it possible drop a constraint on a table by getting the constraint name in a variable and passing that variable to the drop constraint command. Here's an example. DECLARE @name varchar(10) SELECT @name = [name] from sysobjects Where xtype = 'F' and Parent_obj = (SELECT...

Is use of cursors recommended in Oracle more so then they are in SQL Server 2000? From what I have read, cursors should be the last resort in SQL Server. I was wondering if that holds true with cursors in Oracle? All ideas are welcome. I'm on the learning curve here!

Is it possible to configure SQL server agent to send an e-mail based on a system monitor alert? Here's the situation...I have a database that I assume would grow by 20-50 MB per day. I'd like to get notified before the database runs out of disk space. Now, I could do something similar by...

I run a Enterprise edition on a Windows 2k Advanced server with 768MB RAM. Lately, its been consuming all the memory even with no connections or queries running on it. The Total and Target Server memory object show a average value of more then 750 MB most of the time. And that is with no...

Up until now, I did a full backup of the databases on a nightly basis. Didn't do transaction log backups and as result my log file has grown big and now I'd like to truncate it regularly (I was under the impression that truncation occurs with a full database backup!). With business growing...

Recently, one of our database went offline and EM showed it as Suspect. We got to know about it only when the users couldn't logon to the site. If something like that happens in the future, I'd like to trap any error that SQL Server 2000 would throw, and set off a mail to the administrators...

I have set up a alert to fire when the log file gets filled up, and execute a back-up-the-log-file job. How do I test to check if the alert and the job work or not? And also, is there way to specify in the alert to run the job, say, when the log file is 60% full. Right now, it is set to run...

I have not been very successful in setting up e-mail notification on the SQL Server box that runs on a cluster. Are there better ways of doing that? I am looking for ways to notify/send alterts like e-mail using a stored procedure, third party software, forwarding alerts to a non-clustered...

An e-commerce database went 'OFFLINE' after the data server (the server storing the .mdf and the .ldf file for the database was rebooted). It won't show up in EM/Query Analyzer. I tried to restore the database from a full database backup using the 'NO RECOVERY' option. While it was trying to...

When I try to access the link tables in a Access database thru a .asp file, it says the ODBC connection to the DSN (The DSN that the link uses to connect to the other database)failed. In other words, I want to go read the linked table thru the .asp file. Is there a way around this problem...