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 ...
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 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 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 have this procedure..
and if i run for 4 days all ok if i run for 5 it gives the "Associated statement is not prepared" error
any one know how to fix
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 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...
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...
I created a database. In fact I worked on it already,however, I would like to established relationships just like I used to do with microsof Access like one is to many, one is to one,many to...
I am looking to implement Commvault technology for my SQL backups. I have neither knowledge nor experience with Commvault but I checked out their website and Commvault can do SQL data and log ...
I need to create a new user login, and give user access to the database (2005 version).
> Security, Logins, . . created MikeS
> MyDatabase, Security, Users . . Here is has:
User Name:...
Hi all,
I've written the following ActiveX control and used it in a DTS package in SQL Server 2000
Function Main()
Main = DTSTaskExecResult_Success
filePath = "\\sqlsvr1\c$\Firmed.x...
I'm having an incorrect syntax error near the keyword 'AS' and an Incorrect syntax near line 346, which is my last line of code. Can't find the issue? Can someone take a look? Including fil...
I'm running SQL Analysis Manager in SQL2000 and one of my shared dimension is producing an error that it is not unique.
This is the error I'm receiving:
What can I modify to correct the di...
I have a report I have designed that uses references two functions. This stored procedure takes about 5 minutes to run. More importantly, the procedure is supposed to return # of total appoin...
I have 3 tables that i want to report on in Reporting Services. One is an Employee table, another is a Alerts table and another is a Alert Type. All 3 tables arent linked to each other, which ...
I have a table with a numerical field that is the number of days since 1/1/1900. I need to produce a date in place of the numerical information. Can anyone tell me how to accomplish this?
Hi All,
I have been having a lot of trouble dealing with this large amounts of data, in SQL 05 DB. Currently, I have about 7.5 million rows (times about 75 columns) in this one table. Usi...
