I want to update two tables; however, if I'm updatting and something goes wrong then I want NOTHING to get updated.
Also, is there a way to somehow step through or print/echo out the values...
We have a new client and have discovered their database server has no space on their "C" drive. We've deleted log files, docs/settings/etc and have about 50mb. On their data partition, there...
We are a small business and have MSQL Server (I believe Version 8) that has 2 databases on it.
The server is running 24/7. We are doing backups with Acronis Echo Server for Windows. Up until ...
I am trying to configure SQL mail on SQL 2000, I have installed outlook and configured MAPI profile for the same account which i am using to run SQL server and agent service. All well up till ...
Hi,
I'm a novice to SQL Server but not to SQL and relational databases. Here's what I want to do but I'm not sure how to approach it in SQL Server:
I have a stored procedure (call it sp...
I need to return a list of jobs where the most recent charge for that job is 3 business days old or older. Business days are week days (M-F) no Saturdays or Sundays. I also need to exclude j...
I have a Document table of which I pull back DocumentID's that meet certain criteria based on the CurrentStage column. For this particular job I also have a 'batch number' of sorts called an E...
Hi All,
I am installing Blackboard Server on SQL server 2005 ExpressEdition on Windows 2003 R2 Entps
I have installed SQL2005 Express using mix-mode configuration. I can connect to it via ...
I currently have an SQL Express Server in place that I downloaded for free.
How hard is it to upgrade to SQL Server 2005 or 2008?
How do I save a DTS package that I've created in SQL2000 to a xxx.dts file?
Thanks
I'm obviously missing something, but not sure what it is, so I need help.
I have a text file that is generated from a program and I don't really know what the end of line delimiter is (since ...
If an employee is absent before as well as after one or more consecutive holidays and he has not worked in any of the consecutive holidays then treat all consecutive holidays as absent days....
I have SQL Server 2000 and i want to install SQL Server Management Server, how and where?
Hi,
I would like to know if there is anyway i can change the design fo a table without having to tear down replication.
I have a table called tbl_oHeader in it is a field called PreSeaso...
Hi All,
Does any one has a SQL script to copy the DTS to local disk. On SQL 2000 I have about 350 DTS packages which need to be copied on local c:\.
Or is there any other way to speed u...
Hi
I have a table like
user id name address
11 john NY
i want to insert the column names and respective data types of this table into abother SQL table like t...
hi all,
very easy to explain...
I have window 2000 server running SQL 2000
I want to move everything about SQL to a new server running 2003
SQL have database, DTS, jobs.... lot of thin...
Attemping to create table with following statement but getting this error:
Msg 1975, Level 16, State 1, Line 1
Index 'PatCP_keySysIDF01' row length exceeds the maximum permissible length of ...
if they're not given, i'd like @start and @stop to be handled like this:
IF(DATEPART(WEEKDAY,GETDATE())=2)
BEGIN
SET @start = CONVERT(VARCHAR(10),GETDATE()-3,101)+ ' 17:00'
SET @...
Experts:
I need some information on the best way to go about creating some DASHBOARD, GRAPHICAL , CHART type reporting that can be displayed on our call center monitors and that will contin...
I have a query where I am getting "Ambiguous Column Name 'MedListsId'. Basically my goal in this query is to add medlistid twice because I need to join that table to 2 separate tables. See e...
