I have a table populated in sql database, the data for this table is fed from mainframe.
I have a date field and a seperate time field in this table
The time field is in this format
11...
Hey all. Someone injected some code into my database via a website. Now i have a LOT of records in my database and all of my tables that have a javascript in it. How do i get rid of it across ...
hi,
does anyone know how to configure a maintenance plan or job so that after a period of time the full backups are archived/deleted from the server. on our old sql 2000 box there is an op...
I have an access 2000 client that has been running a pass-through query that executes a SP for some time now without any issues. All of the sudden the pass-through runs very slow! When the S...
I have following query, it takes forever to run, can someone pls help?
update TempCard
set ANUMWDATMO = ISNULL((select count(*) from coopi i
INNER JOIN card c ON SUBSTRING(C...
I am going to be purchasing SQL Server 2005. I have currently been using the EVAL version on our web server. It will be Standard Edition 1 processor.
I have seen go for all kinds of prices...
Im running a program and this program comes with SQL. this program is asking for a SQL username and password.now i never set one up nor do i see an option to. Did i miss something?
sql ver...
Hi experts
we have Scheduled a Job in SQL Server 2005 ManagementStudio enterprise edition SP2.
Sometimes it fails with error :
Unspecified error occured on SQL Server.Connection may have...
Hi Experts we are running one job basically a stored procedure that is running
it is failing sometimes can you please suggect as to why it is failing .Iam attaching the stored procedure
if ...
I have created about 50 reports and I will like to provide access based on Active Directory. Can anyone supply me with information on steps to follow to integrate groups in AD to the reports i...
I have the three declare items I need to add as a function and then called in a stored procedure. I have the three items and then an example of how I believe it should look like in as a functi...
Hello
I have a report that has 2 tables, each with it's own dataset. Each dataset is a Stored Proc. I need the Stored Proc associated with one of the datasets to execute first. At the mo...
I need to create scripts to move
DTS packages
JObs
from SQL 2000 to SQl 2005
We have only a PRMIARY group with three ( 3 ) files in the filegroup. I would like to create four (4) files in the SECONDARY
filegroup and leave only one (1) file in the PRIMARY filegroup. H...
Hi,
I'm having some issues installing SQL Server Express 2005 with Advanced Options. I installed the base version with no service pack and all options selected on a Small Business Server (no...
I'm new to Microsoft SQL Server 2005 Management Studio and within the program there's something called 'Views'. What exactly are these and how are they used?
Any examples would be great.
...
I have an MSSQL 2005 Database with 540MB in Data and 3.7GB in transaction log.
Both the Data and Transaction files are set to 10% increment with unlimited growth.
The disk has 25GB free.
I ...
The error messages continue with "[SQLSTATE 42000][Error 10054] OLE DB provider "SQLNCLI" for linked server "servername" returned message "Communication link failure". I'm trying to have a jo...
I have a stored procedure that has @BeginDate and @EndDate as parameters. I created a report with a default for both. They run just fine. After I deployed, I created Linked Reports and want...
We are running SAP 2005 SP1 Patch level 12 on a Windows Server 2003 Standard with SQL 2005 no SP1 yet.
Our SAP/SQL database would randomly lock up and the clients would not be able to connect...
Hello Experts,
I am looking for detailed info about 'Linked Servers'. To access objects between the servers we need to create a linked server. I am not sure how? could anyone guide me throug...
How difficult is it to upgrade from SQL 7.0 sp4 to SQL 2005 standard edition. What are prcautions that i should do before. and after. Should i upgrade from 7.0 to 2000 then 2005 or just go rig...
hi there. i do not understand how to use an attribute in a calculation. In the query below, I'm trying to say:
for all members of the date.calendar hierarchy, show me the sum of (sal...
Hi experts,
Trying to install SQL 2005, on SBS 03 R2 Premium.
Through the installation, SQL goes about installing required components namely .NET Framework 2.0.
All looks well, as in it...
We have SQL Server 2005 back-end with an Access 2003 project front-end. Frequently, we have batch processes than need to be executed that take quite a while to run, 2-30 minutes.
When ex...
