Dear Experts,
I've being struggling to find a solution for this:
I have an SQL Server 2005 installed, and 10 clients connected.
I have a client running Priority application, and after som...
What's the format that server, instance, and port have to appear in a sql server connection string?
Thanks
Hi
I am working on migrating to a Warehouse Management System, which has an SQL Server 2005 back end
At the moment, i have an external program which creates carrier labels, based on a fi...
I know there have been plenty of people asking the same question, and I have tried to follow instructions and do what have worked for others. Problem is I dont seem to get it to work. It shoul...
When I try and backup a database I'm getting the following error:
Executing the query "BACKUP DATABASE [STS_Content_TFS] TO DISK = N'D:\\Program Files\\Microsoft SQL Server\\MSSQL.1\\MSSQL...
I'm trying to execute a command shell statement from T-SQL without using xp_cmdshell. The reason is that I would prefer not enabling xp_cmdshell on the server.
For example, using xp_cmdshe...
If I use the CSV file csvtest.csv with data:
ID,First,Last,DOB
1,James,Smith,19750101
2,Meggie,Smith,19790122
3,Robert,Smith,20071101
4,Alex,Smith,20040202
and Query
DROP TABLE CSVTe...
Being very new to SQL Server 2005, I am creating a dml trigger on one of my tables. When ativated, i want to obtain the old value (if one exists) and the new value of data that has been entere...
Hey guys,
We are in the process of migrating from SQL 2000 to SQL 2005. I have been copying databases using the copy databse task. Several have worked and a couple have not. One of the d...
I'm trying to import an Excel 2003 datasheet into SQL Server 2005 SP3, with SSIS installed and reinstalled. I get the folllowing error:
Error 0xc00470fe: Data flow task: The product level i...
Hello, in SQL-Server, can someone please give an example of the SQL syntax of how to concatenate two columns?
Thanks
Hello
We are using SQL Server 2005 Standard Edition 64 bit, running on Windows NT. Last night, I moved the system databases to the C drive to a different drive. The box has six instances. I...
In C#.net I'm using
updateSQL = " UPDATE [tbl_datatable] " +
" SET [birth_date] = '" + txtBox_BirthDate.Text.ToString() + "'" +
...
Hi..
i am getting the following error message when i try to login to sql server 2005
I created a new login called vensgal when i logged in wth the windows authentication mode.
then i t...
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...
When I look at my fields that I have designated as DateTime, they have the same setting in the database. Whatelse am I missing? Here is the code:
@REFERRAL_DATE DateTime,
@DATE_OF_APPOIN...
I am running Veritas Netbackup 6.5. I have a couple of sql servers with multiple databases on them. I've heard that Netbackup can backup sql databases directly. I'm not sure if there are custo...
SSIS package "MEDPAR_Patient_addyear.dtsx" starting.
Error: 0xC002F304 at Bulk Insert Patient Records 1, Bulk Insert Task: An error occurred with the following error message: "Cannot bulk loa...
hi,
i am having a problem here with writing a SP to find out what is the current work shift, especially with work shift timing that goes beyond midnight.
The shift time is taken from a ta...
For a client that needs to see non-CRM reports inside MS CRM 4.0, I've created the following solution:
Due to design considerations and limitations on the size of the URL that MS CRM will p...
Hey everyone,
I'm using SQL Studio 2005 and want to export the queries I run in the Analizer to Excel...including the column headers.
Do I set that in the options somewhere or code it?...
Hi
I've to insert and retrieve a graphic to/from SQL Server 2005 dbase for use on ASP.net 2.0 page.
I've tried some links but never quite got there.....so code would be better this time
...
I applied the cumulative update package 3 (build 3186) to my 64-bit SQL 2005 enterprise SP2 clustered instances in order to fix an error which was preventing me from modifying my SQL jobs or d...
I am trying to teach myself SQL Server as part of an ongoing E-Commerce project. I am using on online tutorial that tells me as Step 1 to open the Surface Area Configuration and then open Surf...
I am making some changes to most of the 700 stored procedures on one of our applications.
I want to create a script that generates ALTER statements for all stored procedures.
So far I have a...
