Hello,
We are upgrading to a new 64 bit server, running Microsoft Server Standard 2008 64 bit and SQL Standard 2005 64 bit (from Server 2003 running SQL 2000)
In the past we have always ...
Any idea how to create a backup device on SQL 2005 so that all the backup will be stored on the tape ?
When I start the SQL Server Management Studio --> Server Objects --> Backup Devices, r...
Hi Experts,
I have created the dtsx using Business Intelligence Development Studio , and then, could you please advise how to put it on to the SQL Server 2005, and then schedule it to start...
I get the following error when I submit a package
SSIS package "Package1.dtsx" starting.
Information: 0x4004300A at Data Flow Task, DTS.Pipeline: Validation phase is beginning.
Information:...
I have a table in my database called crmAfterCareData. I've also created a View that holds some info from another table (crmApplicationData_ToUse) and some data from crmAfterCareData. My View ...
as above. have already install 1st and default SQL server instance but cant install a 2nd one! it has sp2 installed also.
Hi Everybody,
I have to generate a huge xml report in Sql Server 2005 Stored procedure. I can not take varchar because of maximum length limit. So decided to take XML Variable but unfortuna...
Hi, I have report parameters being passed to a store procedure dataset. That works fine. I confirm that my SQL table has the results I expect. Then I added a table to the same report, and use ...
I am dynamically generating an insert query. i.e. at run-time, I will come to know which table is going to be used and which fields of the table are going to be used in the query. I want to ex...
Hi,
I need to read 1,000,000 rows of data from a SQL table and have been using the ExecuteReader function which has proved to be much too slow. Could someone please advise on the best, (e.g...
Greetings:
Just as the question states, we have been using SMALLINT to define USER IDs throught our schema. The concern has been raised that unless the schema is changed so that USER IDs a...
Hello All,
I have a table in a SQL 2005 database that needs to be updated. There is one field which is currently blank and needs to be populated.
The Excel file which contains the needed...
Does anyone know how to dump data from an MS SQL database with pre-made insert statements without hand coding for each table?
I know about querying INFORMATION_SCHEMA.COLUMNS etc but don't ...
The sql function in the the snippets window gives "green" for ALL rows that call it in an insert/update/select statement. The insert pulls rows from one table to another and doing a calculatio...
I have a log file that has grown to 18gb and I am afraid to leave for the weekend without doing something about it. We only have 10 gb of space left on the SQL Server c:\. I have my it guys ...
Hi,
Hi,
I have a problem when scheduling a report on my Reports Portal, when i try to get the email functionality to attach the report and send an emai.
I have no problem when i sche...
We have been using a vendor in an ASP environment for some time now. We have decided to move to an inhouse server and the vendor has sent us our data in a .bak format. They said it was a bac...
I am trying to create a report that takes Product Name & the start and the end date as a parameter...
Product name apply parameters @ report level...
Start and the end date apply parameter...
I am using SQL Server 2005 and trying to import data from an Excel 2007 file into my SQL Server database. Previously, when importing from Excel 2003 it was very simple (just specify Microsoft...
I have a cube that includes two fact tables from the data warehouse: SalesOrderFact and AccountsReceivableFact. Both have SalesOrderNumber in them as a degenerate dimension. In order to inc...
HI
i have one table tbl1 with 4 columns col1 in ,col2 int ,col3 int ,and col4 BIT
i need to create check constraint to apply the following rules
- If col2 has a value then columns col1,co...
I'm logged in to SSMS via SQL Authentication. I can create tables, and create FK constraints at the time of table creation, but not via the Alter command on existing table. What do I need to d...
I am using SSRS 2005 on a internet web server.
I receive this error message when attempting to run the reports in debug mode with BThe underlying connection was closed: Could not establish ...
Hi
I am using VS 2008 EXPRESS EDITION and MS SQL 2005 Express edition.
Why is text file handling so frustrating in vb.net?
I have been trying to look up an example of code that would le...
I am running a stored procedure with a VarChar as parameter. when i run the SP it gives me the error
execute Sp_Insert "2;2;2;2;2;2;2;2;2;2;2;2;2;2;2;2;2;2;2;2;2;2;2;2;2;2;2;2;2;2;2;2;2;2...
