Search results for query: *

I need your help. I want to send an email with data from 2 selects, one with only one row and another with several rows (details table). Tested separately, works very well, but it doesn't work when I want to put both results in the text message...

Hello, I have a table with 2 columns: Name SerialNumber 123 4GB6Y78 123 53F7TH 124 4GB6Y78 124 53F7TH 124 53E8BX the question is : how to get the results as following: 123 4GB6Y78 53F7TH 124 4GB6Y78 53F7TH 53E8BX ... 125 with 6 columns.... etc... Thank you very much!

Hello, I need your help. I will tray to explain you what is my problem I must create a sql server 2005 database that will be used by a .net application. This database will contain scanned bills too. The client told me that we will have around 40 000 files every year and each file is...

Hi, I have a stored procedure that was implemented last year. This procedure is used once every month from aspnet page, to import data from csv file to sql server table and it takes less than 1 minute. It was ok last month but yesterday, when the client executed the same storproc he had a...

hello, i whant to know how can i rewrite this query to not use select from()...... and select from() in the where .... thanks very much select 'COST_REVENUE' AS COST_TYPE, cr.source_system_id, cr.Trans_Sequence_No as Trans_Sequence_No, Source_System_Id +...

I need your help! I am a dba, with not much experience like developer. I want to modify a stored procedure where a part of the same code is repeated 3 times (every time for a different parameter). CREATE PROCEDURE [RptCtrl] @startDate DATETIME , @endDate DATETIME , @userId INT...

Hi, For sql server 2000 I never used the maintenance plan, I always used jobs to solve my maintenance problems. This year I will migrate to the 2005 version and I would like to know if you already used that, if the maintenance plan is stronger, because I do not find information concerning the...

Hi, I must transfer an oracle table to sql server with DTS. A column is varchar type in the oracle table and is datetime in sql server table. For the transformation I use this: DTSDestination("col_date") = convert(datetime,DTSSource("col_date"),1). When I run the DTS I have this error...

Last week last I passed an interview for a junior dba sql server job and the dba asked me these questions. 1. You’ve been given the task of automating a refresh of a sql server database on a test server with a copy of the live database from the production server? How would you go about doing...

Hi, Please, I need your help. I am a junior dba sql server and I want to know if I must install oracle client to connect to an oracle database, with Oracle Provider for OLE dB. I want to create a DTS which will run every week and will transfer an oracle table into a sql server table. Thanks...

Hi, How to change this code to send 2 parameters in a new page? This is the code that i found for only one parameter: Function MakeURL(ByVal strURL As String) As String Return "prodpage.aspx?sName=" & strURL End Function <asp:HyperLink Runat=server NavigateUrl='<%#...

Hi, I have an application that use a stupid replication with source and target database on the same server. Now I want to test my restore plan and I want to use a dev server. Every time when I want to install replication a red x sign appear on the Replication Monitor. I don’t have this...

Hi, I want to buy of my 25 sql servers 2000. Can you suggest me something, please? Thanks in advance!

Hello, I want to know if I can do a replication between two databases on the same server(same instance) and between two databases on two different servers with STANDARD edition. What's more, I want to know where I can find information about replication. Thanks a lot,

How can I use local packages in an external scheduler? For all jobs in the company we use an external scheduler (CONTROL M ). Once per week I must send data from oracle database to sql server database. For this I use DTS. All work fine but I don’t know to use this in our external scheduler...

Hi, I have a maintenance plan and implicit a daily backup, at 22 PM. I want to take this backup (the last backup from device), to zip and to send the file to a second server, unzip and restore the file. My problem is that I don’t know how to put this file into my variable. Any idea? Thanks for...

Hi, How can I create an alert to test if the database is up? I am beginner in sql server. Thanks in advance, ersatz

Hello, I am not able to restore my database. The backup file is on one server and the database is on another. When I click on: restore database/from devices/select devices/device name I find just C: and D: drives, I don’t find the drive that I mapped. If I try to write \\server_name\d$\...

Hi, I have to manage a SQL Server DB who is used by a web application - server A. We have also an other server for special situations (disaster, for example) - server B Both have installed a 2003 Win OS and a 2000 SQL Server Standard Edition. Q : What kind of backup /restore strategy I need to...

Hello, I am in charge with the administration of a sql database (I am in charge since a few days and I’ll start a course in a couple of weeks). Presently they make tests and we have a problem. I do not know if it’s an application related problem or a sql setup problem. There are several...