Hi,
I have added in MSSQL linked server to Progress v9.1C database using such commands:
EXEC sp_addlinkedserver
@server = 'SAF',
@srvproduct = '',
@provider = 'MSDASQL',
...
I have an insert statement that looks like this.
Insert into databasTable (col1,col2,col3) values(id + '" + callBackTime + "','" + reqCallDuration + "','" )
I accept input from 3 differ...
The on my MSDB database the transaction log is 71GB, although the database itself is only 223MB.
How can I shrink it to a more manageable size?
Orginally it was about 30GB so I setup back...
From a stored procedure, can I call a custom function that will return the table name I want to use in my SQL syntax?
thanks in advance,
Bill
I'm trying to import data from Excel to a SQL table (SSIS)
All fields go in ok, except a memo field, which has variable, long text (notes).
I've attached the SQL error, it says it cann...
Hello,
I have 2 Sql Servers Express 2005.
I am having trouble to execute some query from server B wich has server A as linked.
Can somedy tell me please exactly what are :
@provider= ...
Hi, we have a Sql server 2005 engine in a fail over cluster, database, log and quorum disks are on logical units on a IBM fiber channel 2gb SAN.
We are running it on a windows 2003 enterprise...
SQL Server 2005 Standard Edition 32bit - SP2, Windows Server 2003 Enterprise Edition
IO Completion Listener (0xabc) Worker 0x00C760E8 appears to be non-yielding on Node 0
SQL Server has enco...
Hi everyone,
I have a question regarding using custom assemblies in SQL Reporting Services (2000 or 2005). I created a custom assembly that I am trying to use in Reporting Services. In ...
Hi experts
I have to get the time difference from to smalldatetime fields ins sql
The fields are called calldt , call_end
The format it needs to be in is hh:mm:ss
Thanks for any help
Does anyone knows how I can make dynamic the width of a column in Reporting Services?
hello
for ex you have rows in a table and a columns value is:
1
2
3
5
6
you see how 4 is missing
I'm looking for a quick method to find just the first lowest missing number or gap
a...
I have a straightforward sql select query and I would like to send the reults by email once an hour or so, with the data in a csv - is that easy enough to do or do I need some third party soft...
Follow up question:
This query works perfectly in terms of returning the recordset that I asked for: (thank you for the help)
select
Max(jobID) as jobID
, JobMasterID
from...
We are preparing to upgrade our SQL Server 2000 to SQL Server 2005 Standard. We will be performing a Side by Side upgrade so we can move 1 or two applications at a time, and keep the others ru...
Hi,
I'm trying to import a .csv file into my SQL Server.
Please see an example of two lines below (hopefully it's come out alright), the 2nd line of data doesn't enter correctly, and gi...
Hello,
I am really new to Visual Basic 2005 and SQL Server 2005 (I used to program in PHP/MySQL) and I am struggling to figure out how it all works.
I have created a database which will ...
I am developing a WebApp in Visual Studio 2008 with a SQL Server 2005 backend. I have a table into which I import data from an Excel file. This works fine. What I need to do is move the dat...
Hello,
I want to import data from an excel file to Sql Server 2005 express.
I am using Excel 2000.
I am executing the query attached, while the excel file is not open, and it is in the di...
I am having a difficult time getting my head around using XML as a passed value to a stored procedure. I have the following example (I removed all Declare statements that reference the variab...
Hi Experts
I have a SBS2K3 Server running SQL Server 2K5 Express. For querying purposes I want to import an Access 97 Database into SQL Server 2K5 Express.
I have been trying to use Micro...
When i want to install SQLServer 2005 on Windows Vista Home Basic, I get a warning about not having IIS on my computer. As you know IIS doesn't exist in Windows vista Home basic. I want to k...
Hi,
I am using reporting services 2005 and I have the following master/details report dilema.
I am building a report whose part of the content depends on the user selection. Depending on t...
We have a Biztalk orchestration that calls an SSIS package, via a .net C# utility class The package is deployed in SQL server and runs fine most of the time. eg: you could continuosuly run the...
Hi,
I am working on MSSQL 2005
I want query help
Suppose in table t1, I have field f1 and f2
now the details in the tables are as folows:
f1, f2
1 a
1 b
1 c
1 d
1 e
...
