GetDate() - From Server Machine Or Client Machine ?

Oct 23, 2006

Hi,

If I use GetDate() function from client machine (using "\ServerMachineSQLExpress" instance from client machine "ClientMachine"), then from where I will get the DateTime value ?

From "ServerMachine" or from "ClientMachine"

Thanks

View 3 Replies


ADVERTISEMENT

Could Not Connect Server From Client Machine

Dec 12, 2006

Hi all

I m a new member to this forum. Im a hardware engineer who rectify aome software related issues. Now our employees having problem with connecting their XP prof based clients to 2003 server from SQL query analyzer. I tried refresh sql server manager in server and tried restarting the server machine many times. sometimes it the client machine connects and disconnects immediately. i aslo tried changing the poll interval , but no use.

waiting for a speedy solutin... i know this is as easy query.



View 4 Replies View Related

Copying Database From 2000Server Machine To 2003 Server Machine

Jul 23, 2005

Hi All;We are going to change our application server. We will copy all of ourDatabase from Mic 2000 Server OS to Mic 2003 Server OS. I found anarticle that how to move all the folders from same OS. My question isthat Would the 2003 OS be a problem when we copy all of the MC SQL 2000folders to New OS ? Has anybody done this before? Could you gimme yoursuggestions please?ThanksASA

View 1 Replies View Related

How To Set Client Machine Name When Using ADO To Connect To SQL Server 2000?

May 15, 2007

When you connect to SQL Server using SQLConnection, how to set client machine name(or IP address) so that you can monitor the process on Server side using Enterprise Manager?

View 2 Replies View Related

How To Insert Record To SQL Server Which Is On The Other Machine From Client Computer?

Jan 14, 2007

I want to write simple sql database project that that works in the network. and i need to insert record from a client to a server that is on the other machine.

View 1 Replies View Related

Execute SSIS Package Stored In Remote SQL Server From A Client Machine.

Mar 3, 2006

I have written a VB component to execute a SSIS package stored in SQL server.

I am using the Microsoft.sqlserver.dts.dtsclient, dtsconnection/dtscommand

and executereader and everything works perfect on the local machine. This is descibed in a msdn site .

But my customer have a remote SQL server and want no extra BI clients/SQL server clients etc on the client machine, only an ordinary windows client and network connection to the SQL server.

My question is: Can you still use dtsclient or do you have to do in some other way?

rose-marie

View 4 Replies View Related

Ssis Package Hangs On Script Transformation When Running On One Machine Not Developing Machine

May 4, 2007

Help!
I am using Script Transformation to output a new column as image[DT_IMAGE]
field to store serialized object. In the VB script, the sample code as

Row.serializedobject.AddBlobData ( binaryArrayReturnedFromC#dll )

The package always runs fine on my developing machine and will halt on other
machine at AddBlobData after certain number row records were processed. I am
stuck here. Anyone has any suggestion?

What I need is reading data from mutiple tables in one database and writing
into a single table in another datable. In order preserve all the columns
data, I use input column fields to construct a new object and then serialize
it, and store the serialize data into detination db table. (The object and
serialization function is coming from c# dll.)

Dim b As BusinessLicense = New BusinessLicense()
b.ApprovalDate = Row.approvaldate
b.BusinessId = Row.busid
b.BusinessName = Row.busname
b.NaicsCode = Row.naicscode
b.NaicsDescription = Row.naicsdescr
b.OwnerName = Row.ownername
b.Phone = Row.phone
b.Pkey = Row.pkey
b.RenewalDate = Row.renewaldate
b.StartDate = Row.startdate
b.Suite = Row.suite

Row.serializedobject.AddBlobData(Serializer.Serialize(b)) '''----This is blocking line
Row.infoType = BusinessLicense.TYPE



Both machine is xp with sp2. and standard SQL Server 2005 - 9.00.1399.06

Thanks!

View 4 Replies View Related

SQL 2005 Enterprise Edition The Image File Setup.exe Is Valid, But Is For A Machine Type Other Than The Current Machine

Nov 28, 2006

Hi All,

I have enterprise version software CD1 and CD2 of SQL server 2005

when i try to run setup.exe..the following error pops -up

The image file Setup.exe is valid, but is for a machine type other than the current machine

MY OS version is windows 2003 32bit Operating system...

I am suspecting the binarie may be of 64bit.. How do we check the binaries are 32 bit and 64 bit software

Thanks for your Help

Mohan



View 4 Replies View Related

Copy Dts To Client Machine

Dec 12, 2007

hi for all...
i've create a dts using MSsql2000 and finish it my question how could i download the dts to client machine i don't want recreate it in my hand if i could create a setup for the dts it will be great or if there is a command using osql for that
it will be nice
notice : i save it as structered storage file if it could help

thx for help

View 1 Replies View Related

Connection Pool Leak In Production Machine (in Other Machine It Runs Well)

Nov 16, 2006

Hi to everyone,
I'm facing a problem that drives me crazy. I've a web application that has the following problem. When I test the application on my developement machine all runs fine, but when I put into production server there is a problem in connection pooling. Look at the following image, the blue line is the number of connection in the pool and the violet line is the number of connection reclaimed. From the image it is clear that connection are returned on the pool only in block, maybe when the garbage collection pass and reclaim the object. The strange thing is that on my developement machine all is good, and also I'm using Enterprise Library and the connection are managed internally.- Thanks to everyone for any help.   

View 2 Replies View Related

Running A Stored Proc On A Standalone Machine From Another Machine In A Domain

Oct 2, 2000

Hullo all
I have two machines,
One is a standalone machine and the other is on a domain network. How can I run a stored procedure/job on the standalone machine from the domain machine ?
running the procedure as a Domain user results in a failed job/stored proc.
also creating an sql login and attempting to run it as that user also fails. How can I solve this problem ?
please e-mail me at wayde@sunnygrp.com if you have any thoughts...

View 1 Replies View Related

Select Data From 2000 Machine From A 2005 Machine

Jan 17, 2008

Hi,

here goes the question:

i have 1 sqlserver 2k5 machine (machine A) and sqlserver 2k (machine b)

how do i build a query to select data from 2k machine in a query of 2k5?

i mean something like

select *
from login:passw@machineb.dabatase.dbo.customers

thanks!

View 2 Replies View Related

Select Data From 2000 Machine From A 2005 Machine

Jan 17, 2008



Hi,

here goes the question:

i have 1 sqlserver 2k5 machine (machine A) and sqlserver 2k (machine b)

how do i build a query to select data from 2k machine in a query of 2k5?

i mean something like

select *
from loginassw@machineb.dabatase.dbo.customers

thanks!

View 6 Replies View Related

Installing Sql 6.5 Client On 2000 Machine

Mar 26, 2001

i am trying to install SQL 6.5 client on 2000 box. but the installation wants to install an SQL 6.5 SERVER on it. Is there something im forgetting?
is there a way and if so how? if not, is there a workaround with out upgrading the sql 6.5 server.

Thank you in advance

View 1 Replies View Related

Start Backup Of An Sql Db From A Client Machine

Apr 22, 2006

Hi nice forum you have here.

Please point me to a link on this forum if I’ve missed something but I could not find an answer to this question yet.

I am new to sql and am looking at running random backups of an sql database. Regular backups are running nightly using maintenance jobs in enterprise manager. These random backups would be started at a point in time just before a specific procedure was run. There will be a user assigned the task of running these backups who has no privilege to log onto the sql server machine (nor will he ever get this privilege).
I would be interested to know if there is a way to script this so that this user could simply start a backup from his workstation. The backup could be a repeat of the scheduled nightly backup storing to the same place or a new backup. The db in question is only 150 +/- MB so time involved in completing this job is minimal (the scheduled backup of this db completes in under a minute).

System is SQL 2000 sp4 on a Win 2003 server with XPpro sp2 clients.

Thanks for any tips, hints or detailed descriptions.

Regards

HT

View 4 Replies View Related

How To Install Reports On Client Machine

Aug 9, 2007

Hi
I am developing a Report Project ,that contains some reports
using VS.Net ,My task is to install these reports on client Machine.
Is there any option to add a "Set Up Project" to the Report Project solution, so that client may run this setup project(.exe) to install the reports in his server.

My Main requirement is , client can install these reports into his machine by executing a set up file.
Is this possible?, Please suggest me a good solution

View 1 Replies View Related

Execute Windows On Client Machine

Jul 23, 2005

Hello.How to execute add users window, backup wizard and other windows fromEnterprice Manager on client machine? Does MDAC or sth is able to do this?bye...--__ __|__\ | || |_// / \ \_// FreeBSD: The Power To Serve|__// |__|| | \ \__// / \ +------------------------------++[ http://bukox.prv.pl ][ http://total.bukox.dmkproject.pl ]+

View 1 Replies View Related

Client Machine Accesing Sqlexpress

Oct 3, 2006

This may a silly question but....

I wrote a vb 2005 application that access sqlexpress for data using sqlconnection (.NET). The program works fine. When I run debug on my code that is in my laptop, it access my xp server box with sqlexpress running and I see all my data in my application. My question is..When I compile this program and install it on a client machine that has no sqlexpress tools, no SQLCMD etc....will the application run and access the xp server box, or do I have to install something on the client machine.

thanks

View 1 Replies View Related

Installing SQL 6.5 And 2000 Client Utilities On The Same Machine

Aug 24, 2004

Can I install the client utilities for Microsoft SQL versions 6.5 and 2000 in the same machine?

Please, provide me with any information or links in this matter.

View 5 Replies View Related

Local Storage In Client's Machine In .sdf File

Apr 2, 2008



How to create a db in clients local machine with sql server ce and .net?Is any sample applications available?so,that later i can sync the data to the sql server db.
Please help.I am new to sql server ce.

View 3 Replies View Related

Accessing Report Builder From Client Machine??

May 14, 2007

Accessing report builder from client machine in which there is no sql server with the url http://<server name>>/reports. The report builder tab is not getting displayed.
when accessing from http://<server name>/reportserver/reportbuilder/reportbuilder.application it gets connected to the report model but when we are running the report it say the user doesnt have sufficient permissions or database can not be processed.

The permission is given to the user on the data source. For admin permission the report is running fine.

Do anybody know the procedure to run adhoc reports from client machine??

Urgent!!

View 2 Replies View Related

Cant Get Access Database Synchronizer Set Up On Client Machine

Apr 17, 2007



I have created a PPC application that uses ADS to synchronize my sqlce db with a desktop MS Access database. It works fine on my computers, but my client cant get it to work on his. Here is the situation.



His "Computer Name" as it's stated in his 'My Computer' properties is "PAVSGP024FE.NWFSC.NOAA.GOV"



However his Access.MDW File is located in the directory "C:Documents and SettingsJoe NobodyApplication DataMicrosoftAccessSystem.MDW".



There is no directory called "C:Documents and SettingsPAVSGP024FE.NWFSC.NOAA.GOVApplication DataMicrosoftAccessSystem.MDW".



His current config.xml file looks like this.



<?xml version="1.0" encoding="UTF-8"?>
<SystemNode>
<AccessDB>C:Program FilesNOAA Release LoggerNOAA_ReleaseLogger.mdb</AccessDB>
<DeviceDB>Program FilesNOAA Release LoggerNOAA_ReleaseLogger.sdf</DeviceDB>
<Login>Joe Nobody</Login>
<URL>http://Joe Nobody:1024/</URL>
<WinDir>C:</WinDir>
</SystemNode>



He has tried adding port 1024 as an exception for his firewall settings, has installed Access Database Synchronizer on his computer, and I have also tried using the "long" computer name as the url setting in the config file. (i.e. <URL>http://PAVSGP024FE.NWFSC.NOAA.GOV:1024/</URL> but this throws the error



"The HTTP request failed due to incorrect format or content. Try restarting the IIS server.[]"



I dont know what else to try! Anybody have any suggestions?

View 5 Replies View Related

Restoring Backupfile Residing In A Client Machine

Oct 11, 2007

hi all,

Is it possible to restore a SQL server Backup file residing in a client machine?. I dont have network access to the Server's
drives to copy the backup file, eventhough I am having SA privilege on the SQL server instance.Can anybody help me?

Thanks in advance,
Sanoj

View 1 Replies View Related

My First Experience Distributing The New-built Sql Db Onto Client Machine?

Dec 14, 2005

hi i am new to mssql db stuff. I just developed my first VB.NET application and it uses a mssql database which is hosted locally on my development machine. I built the deployment msi file for my application which can be installed easily on client machine, but have no idea how to move the mssql db with it.

View 1 Replies View Related

Migrating SQL 2005 Test Machine To New Machine

Jul 13, 2007

Hi Guys,

I was wondering if there was any white papers on the migration part from microsoft?
Apparently the situation is like this
Currently installed MOSS 2007 in a testing pc as application server. This application server will refer another testing database server which running SQL Server 2005.

Now, wanted to move this 2 temporary server into another 2 new servers.
Correct me if I'm wrong, it cannot be done by using image like Norton Ghost due to difference hardware spec.

So, if I install another fresh copy of MOSS2007 & SQL server 2005 in that 2 new servers, how can I migrate the contents, documents, etc from the testing database server?

It would be great if someone can show me the links to kb article. Thanks

View 1 Replies View Related

Not Able To 'Step Into' The Procedure Code In SQL Debugger From Client Machine.

Jul 25, 2003

Hi,

I am working on SQL-Server 2000 (developer edition) with SP3 on Win 2000 and Clients are Win98/Win XP.

I am not able to 'Step Into' my SQL Procedure code in Debug mode, executed from Query Analyzer from a client machine. As soon as I select the 'Execute' button after inserting all the parameters value, the whole procedure gets executed. But I'm able to do the same (i.e 'step into') from the Server itself.

Do I need any additional configuration settings in the client machine ??

I shall be greatful if anyone can help me to solve the above problem.

Thanx in advance.

Surajit

View 2 Replies View Related

DTS Execution From Client Machine Fails Connecting To Oracle

Jul 20, 2005

I have created a DTS package that pulls data in from Oracle into SQLServer. When I run it directly on the server (from EnterpriseManager), it works fine. When I run it from Enterprise Manager on aclient machine that does not have the Oracle client software, it doesnot run, giving me the error: "The Oracle client and networkingcomponents were not found...". I was hoping I wouldn't need to havethe client software installed on a machine other than the server whereSql Server is running. The problem here is that there are a number ofmachines from where I would like to execute this DTS package that I donot want to install/configure the Oracle client software. I don'tquite understand why the configuration of the client is importanthere. In my mind, when I am using enterprise manager from a clientmachine, I am using it sort of like a terminal services client toconnect to the server. I guess there is a lot more happening in thebackground.Thanks for any feedback,Marcus

View 2 Replies View Related

Login Failed For User 'sa'. [CLIENT: &&<local Machine&&>]

Jan 23, 2008

One of my co-worker changed the sa password today. After that we are getting this error. The SA account gets locked every time. Even within few seconds of unlocking the SA account, it gets locked again. Error message is not clear as what session still using old password and causing the SA account to get locked? Any of our application does not use SA user to connect to databases. We have Tivoli installed on the same system and the GUI of tivoli has the correct password.

Shailesh

View 3 Replies View Related

Executing SSIS Packages From Client Machine Using SQL Express Engine

May 26, 2006

I have few DTSX packages on my SQL server 2005. These packages are supposed to transfer data and stored procedures from server to client Express engine. The scenario is that when user connects with the server he should run some kind of utility or any other way to run those SSIS packages so that the data could be transfered.

Remember the user machine has only SQL Express Engine and the packages are in SQL server 2005 machine.

Can any one help me out how to achive this scenario?

Regards...

View 4 Replies View Related

Reportviewer In Vb.net App Rendering Black Squares In Textbox On Client Machine

Apr 8, 2008



I have a simple text box in a table in the body of a report. This renders fine via IE on both my dev box and the client.

However when rendered within a Reportviewer control on the client, the box show the text followed by lots of black squares. Running the app on my dev box is also fine - no black boxes at all.


The report resides on the server, and the server is fully patched.


Any ideas greatly appreciated!

View 1 Replies View Related

Problem In Accessing The Database(Sqlserver 2005) From Client Machine

Apr 25, 2007

Hi



We have upgraded sql server 2000 to sqlserver 2005 on the development server.

To access the database server, we installed the sql server management studio on the client PC with Admin Account. The .Net framework and sqlserver management studio were installed and I am able to access the database from the client PC using Admin Login. Then we logged off and tried to login as user account on the client PC. From the user account login we are unable to open the sql server management studio. The error is as follows
€śThe proper type library could not be found in system registry€?

The client PC configuration : windows 2000 Professional ( sp4)

Regards,
K.S.Subba Rao

View 1 Replies View Related

Login Failed For User 'TESTadministrator'. [CLIENT: &&<local Machine&&>]

Nov 6, 2006

Hi Friends,

I am getting the below error while installing CSF DevLite edition on

Following is the breif Info

Server Is : Win2003

SQL SERVER 2005 Installed on Same PC

Domain Name is : Test

User : Administrator he is a build in Admin,

PLEASE HELP ME!!!! Thanking in advance.

EVENT LOG 1:

Login failed for user 'TESTadministrator'. [CLIENT: <local machine>]

EVENT LOG 2:

The description for Event ID ( 11609 ) in Source ( MsiInstaller ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: Product: Microsoft Connected Services Framework 3.0 Developer Edition Lite -- Error 1609.An error occurred while applying security settings. Power Users is not a valid user or group. This could be a problem with the package, or a problem connecting to a domain controller on the network. Check your network connection and click Retry, or Cancel to end the install. Unable to locate the user's SID, system error 1332, (NULL), (NULL), (NULL).

View 7 Replies View Related

Installting Sqlserver 2005 On The Client Machine For Windows Application

Oct 24, 2006

Hi
I developed a windows application in Visual studio 2005 and the database is sqlexpress.
I wanted my application to run on another system.For that i have installed sqlexpress 2005 on that machine.But that machine doesn't show me any enterprise manager or query manager for sqlserver.
Is there any solution for this.

Thanks

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved