Hi Guys,
I have two databases. Database A has a scalar function called ABC that takes 2 parameters and returns a bit.
I want to create a synonym in database B called ZXY that points to ...
This is the error I get:
NULL
Starting copy...
SQLState = HY000, NativeError = 0
Error = [Microsoft][SQL Native Client]Unable to resolve column level collations
SQLState = 01000, NativeEr...
Hi,
I have been able to create the table in Microsoft SQL Server Management Studio 2005. i manage to bulk insert the text file into the table however that are some problem with the column of ...
All,
I will have come across a query i want to write that uses 3 tables to of the tables will have a many to many relationship with each other.
This brought me to a question, what is the...
Experts,
I have a query below that works fine. What I would like to do is look at the field "StatusID" in my SELECT and base on the value in that field, change the value of another field in...
I would like to eliminate the cursor from the script below.
I need to check every canadian zip code from the table coordonnee
and update the field CodepostalID with the codepostalID from ...
I'm trying to setup a scheduled database backup on sql using Microsoft article 930615 as a guide.
It all works until the final step when I get the message
"Unable to cast object of type ...
I'm looking for a solution to replacing a cursor in a stored procedure that is used in a loop to process 20k to 1mm records every day. The cursor selects all records from a staging table and ...
I have the following tables
sectors table
sectorid int PK
sector varchar(50)
parentid int (if parent sector null value is inserted)
example data
sectorid se...
In my home pc, i wanna install MS SQL Server 2005. i am having Windows XP Professional SP 2 OS. I have tried to load the SQL Server 2005 Developer Edition. But after that installation, i can't...
I would like to know whether I should create temporary tables in the main procedure or in the called procedure, and please state your reasons why.
Hello Experts... I have a table with columns for CaseID and Notes. There could be anywhere from 1 to hundreds of notes per caseid. I want to create a new table that has each caseid's associa...
I need step-by-step instructions on adding a remote server to a sql server 2005 database.
Here is a basic example of what I'm trying to accomplish.
Database 1 has table X with column named...
Hello,
I have to execute this Sql command attached and i get this error
OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" returned message "Unspecified error".
Msg 7303...
Im running SQL Server Management Studio Express.
I have "Server A" with "Database A1" with "Table A2" (empty table) on My office server. On my machine i have "Server B" with "Database B1" ...
I'm trying to update a column in a table so that it matches a column in another table. The two columns are both of the type float(8). However, instead of simply placing the value from table 2 ...
Hi,
We are using SQL Server 2005 Standard Edition 32-bit on Windows Server 2003 (x64) 64 bit Operating System. Server has 32 GB RAM. We enabled the AWE option in SQL Server Memory setting. ...
I am trying to do a BULK INSERT of a .csv file in to SQL Server 2005, but I am getting two errors that I can't seem to fix. I am using the free version of SQL Server Management Studio.
H...
We just recently installed MS SQL 2005. My boss, who has the only machine in the company that runs Vista, needs to be able to manage SQL. I planned to install MS SQL 2005 Management Studio E...
I am exporting data to an existing Excel file and am having issues adding a new column to the file to populate my data into. I am using SSIS to do this.
I have tried creating a template of ...
Hi EE. I need to take six large tables from a MS SQL Server 2005 database and put them into six tables in MS Access 2003. Is this possible? I do not see any export options in MS SQL Server 200...
The image is not visible in the header of the report viewer. It is visible in the body.
I have a hidden text box in the body, named as ImageStrTextBox . It holds the expression:
=Syste...
SQL Server Reporting Services
Report Builder/Report Models/Ad-Hoc Reports
We are using Forms authentication- we have our own security system that we tied into SSRS that we use for our login....
I did a restore this morning to a database (full) involved in replication:
Database is now up and runing. The replication doen't work.
The error message I get sugest to do a rebuild to t...
Hello Experts,
I have select statement and would like to export the data into a .txt file using Bulk Copy.
Thanks....
