Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS SQL Server


SuperbHosting.net have generously sponsored dedicated servers to ensure a reliable and scalable dedicated hosting solution for BigResource.com.





Remote Attacks On My Database


Hi, I´m new on this forum, I just need help to solve or avoid better saying attacks to a SQL Server 2005 database. I ´ve had some intruders on my database, changing some data on 2 tables. the information there is too important. But i need to know how can i get all the remote address that make some masive updates on my DB. I´ve make some triggers to avoid that, but those peaoples have reach modify data. I think is some user on the same VPN.

Help me please what can i do to get the ip address.




View Complete Forum Thread with Replies

Related Forum Messages:
DOS Attacks
Dear guys
I'm developing a web site that subscribers will directly connect to sql express and send results of their desktop application to database.
So every body, including hackers can easily obtain a login. ofcourse I will restrict each login to execute only one stored procedure specially created for himself and do nothing else. (or anotherquery to verify validity of each user, instead of creating special stored procedures for each one)
But, I'm worried about frequency of running that stored procedure buy bad users. I can limit frequency of running stored procedure, but anyhow each time of such control also takes time. should I pay attention to such matter?
 
I also don't know what if a user tries to broute force server with incorrect user names and passwords repeatedly. does it lead to slowing down the server? again, should I pay attention to such matter?
 
does firewall help? does IP tarcking help? are these enough? if so, where can I find extra information?
 
In fact this problem persists even if I want to redirect user communications to web service instead of direct connection to data base or even using emails. Anyhow hackers can do the same thing but only some more complexity is added to my project. I found this article for IP tracking in web sites http://weblogs.asp.net/omarzabir/archive/2007/10/16/prevent-denial-of-service-dos-attacks-in-your-web-application.aspx . Is this enough?

I wish to know the way big networks do in real world.
Can any one please help me? Infact I'm not a professional in security. what ever kind of extra suggestions will be appreciated.
 
 
regards.

View Replies !
SQL Injection Attacks
Hello, Our Security specialist, is running an audit on one of my systems.  All pages pass except the login page.  It keeps saying I am getting hit with a SQL injection attack.  I filter out special characters, both on the Client Side validation and the server side.It is only the one page I have is failing, and I am beginning to  wonder if it is producing false positives.Protected Sub btnLogin_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnLogin.Click If Not Page.IsValid Then
lblError.Text = "Page Invalid"
Exit Sub End If Dim strMesage As String = ""
If Not IsInputSanitized(strMesage) Then
lblError.Text = strMesage
Exit Sub End If If Not ValueIsValid(txtUserName.Value.Trim) Then
lblError.Text = Globals.Message_InvalidCharacters
Exit Sub End If   Public Function IsInputSanitized(ByRef p_strReturnMessage As String) As Boolean Dim loop1 As Integer Dim arr1() As String Dim coll As NameValueCollection Dim regexp As String = "^([^<>" & Chr(34) & "\%;)(&+]*)$"

Dim reg As Regex = New Regex(regexp) coll = Request.Form arr1 = coll.AllKeys 'Start at 1 so you will skip over the __VIEWSTATE
For loop1 = 0 To UBound(arr1) 'Skip over the ASPNET-generated controls as they will give a false positive.
If Left(coll.AllKeys(loop1), 2) <> "__" Then If Not reg.IsMatch(Request(arr1(loop1))) Then
p_strReturnMessage = Globals.Message_InvalidCharacters
Return False End If End If Next loop1 'If it never hit false retrun true
p_strReturnMessage = "Success"
Return True End Function  If Not ValueIsValid(txtPassword.Value.Trim) Then
lblError.Text = Globals.Message_InvalidCharacters
Exit Sub End If If Not ValidateUser(txtUserName.Value.Trim, txtPassword.Value.Trim) Then
lblError.Text = Globals.Message_LoginInvalid
End If End Sub Here are the other validation routines  'This is a check to make sure that the String Values Entered into the Database field 'are indeed valid and without characters that can be used in injection attacks
Function ValueIsValid(ByVal p_Input As String) As Boolean Dim strIn As String = p_Input Dim x As Integer Dim A As String Dim l_Return As Boolean = True For x = 1 To Len(strIn) A = Mid(strIn, x, 1) 'Check each character in the string individually
If InStr("<>+%|?;()", A) <> 0 Then 'If this is not a "Bad" character
l_Return = False 'tack it onto the output string
End If Next Return l_Return End Function     

View Replies !
SQL Injection Attacks
I am taking a class where the professor really dislikes using parameterized queries because he considers them to be pointless.  Despite the many points that I and a classmate bring up, the only thing he considers valid is using them to prevent SQL injection attacks. To prevent this, he replaces all single quotes with a pair of single quotes.  I know this works for SQL server, but will fail in some others (for instance MySQL also allows ').  Is there other possibilies such as the ' that need to be protected against?

View Replies !
How To Reduce DOS Attacks
Hello to everyone
 
I am running MS SQL 2005 Express I get per day 2-4 hackers attacks trying to login from €œsa€?
Some 37 calls times per second one of attack was continuing 4 days
 
Is there some setting into MS SQL 2005 to reduce that?
 
Can you recommend me good firewall for DDOS attacks?
 
Is it there some legal action that I can take to this people I have their IPs most are from US and Canada?
 
Thank you in advance
val

View Replies !
How To Prevent SQL Injection Attacks
Hi,

On my site I have a simple textbox which is a keyword search, people type a keyword and then that looks in 3 colums of an SQL database and returns any matches

The code is basic i.e. SELECT * FROM Table WHERE Column1 LIKE %searcg%

There is no validation of what goes into the text box and I am worried about SQL injection, what can I do to minimize the risk

I have just tried the site and put in two single quotes as the search term, this crashed the script so I know I am vunerable.

Can anyone help, perhaps point me in the direction of furthur resources on the subject?

Thanks

Ben

View Replies !
What Are Sql Injection Attacks And How To Prevent?
this is a question I put in the sql community in microsoft, but havent be answered in full

------------

I am using dynamic sql to do a query with differents 'order' sentences and/or 'where' sentences depending on a variable I pass to the sp

ex:

create proc ex
@orden varchar(100)
@criterio varchar(100)

as
declare consulta varchar(4000)

set consulta=N'select pais from paises where '+@criterio' order by '+@orden

------------

I'd like to know it it uses 2 sp in the cache, as I read, the main sp and the query inside the variable of the dynamic sql. if so, as I imagine, then I suppose I have to do the main sp without any 'if' sentence to be the same sp, and so taking it from the cache and not recompile the sp

now, I have various 'if' sentences in the main sp (the caller of the dynamic sql) but I plan to remove them and do the 'if' by program -it is in asp.net-, so I suppose it is better because in this way the main sp is took from the cache, supposing this uses the cache different that the dynamic sql in the variable

what do u think? does the dynamic sql use 2 caches? if so, u think it is better to try to do the main sp same in all uses (no 'if' statements)?


-----

They told me this coding is not good (dynamic sql) because it can give control to the user?

I ask, how does it give control to use? what ar sql injection attack and how to prevent them?

I use dynamis sql because I have 150 queries to do, and thought dynamic sql is good

is it true that dynamic sql have to be recompiled in each execution? I suppose so only if the sql variable is different, right?

can u help me?

View Replies !
Preventing SQL Injection Attacks
My site has come under attack from sql injections. I thought I hadthings handled by replacing all single quotes with two single quotes,akaReplace(inputString, "'", "''")Alas, clever hackers have still managed to find a way to drop columnsfrom some of my tables. Can anybody direct me towards a best practicedocument on preventing these attacks?Thank you thank you,Kevin

View Replies !
Attempted Brute Force Attacks
It is not uncommon for me to review the event logs of our SQL Server and notice that someone is attempting to figure out the password for one of the SQL user accounts.........especially the "sa" username. But lately our SQL server has to be rebooted to where it is starting to become a nightly thing.

Last night the SQL Server was bombarded with attempted failed connections for 2 hours before it finally gave a blank BSOD. The SQL Server in question is in mixed mode and is a shared server. Strictly using Windows Authentication mode is not an option for us. The server has "beefy" hardware and has all updates and patches.

Sometimes, when I log on the server and notice that an IP address is making such attacks on the server, I put up an IPSEC policy against that IP. But that is not a good solution for reasons I dont think need to be outlined here.

So my question is, what can I do to better protect our SQL Server from these types of attacks? My thought on these attacks is not different than a DDOS that eventually takes the server down.

I have already done TCP/IP Hardening but not sure what else to do.

Thank you all for your replies.

View Replies !
Injection Attacks Myth Or Fact?
Greetings all,

 

For entertainment purposes, I've been reading some articles on SQL Injection Attacks and there should be a cover charge to read these articles. (excuse the sarcasm)

 

Most defense is based on the use of stored procedures or read only settings on the tables.

 

I'm looking for practical opinions and possibly some code that would convince me personally that this is indeed a real threat.

 

Also, if possible, please post remedies that are solid and not open ended.

 

Thanks all,

 

Adamus

View Replies !
Import Wizard - Using Query For Remote Database To Compare Local Database
I am trying to use the Import Wizard to setup a daily job to import new records based on an ID field (PK). The source database is remote and a replica. I am inserting new records to update my table called the same thing. Both are SQL Native Client
 

Code Snippet
select *
from [CommWireless].[dbo].[iQclerk_SaleInvoicesAndProducts] as S1
join [IQ_REPLICA].[dbo].[iQclerk_SaleInvoicesAndProducts] as S2
on S1.SaleInvoiceID = S2.SaleInvoiceID
where S1.SaleInvoiceID > S2.SaleInvoiceID

 
When I parse the query, I keep getting an error message.
 
Deferred prepare could not be completed.
Statement(s) could not be prepared.
Invalid object name 'IQ_REPLICA.dbo.iQ_SaleInvoicesAndProducts'. (Microsoft SQL Native Client)
 
Anyone know an easy why to get this to work? Or should I add a create table to verify new records?

View Replies !
Remote Database
How can I connect to a remote database, based on Microsoft sql server? Is there any article that can help? I have read few over the net, but not working for me yet  

View Replies !
Could The &&"ADS&&" Access Database Sychronizer Wizard Accomodate A Remote Database?
 

I've used the ADS sample program and it works well. I looked at the code and changed it to VB (sorry, I'm not biligual yet), and have tried to 'adjust' it so I can connect to a remote PC (XP running IIS) instead of the local PC using the workgroup information database (system.mdw). Any ideas of the connection string that could make the connection?..my intention is to RDA once a week between a mobile device (3g/gsm) and a 'poor man's' IIS web server.
I've tried everything I can think of, and I'm sure its possible since all I'm doing is changing the connection path.

View Replies !
How To Backup From Remote Database
hi all,
I have a remote(online) database of my web portal.
I want to take backup of that remote(online) database to my local machne.
This is SQL Server 2005 database.
Please tell me how I take backup of my database?

View Replies !
Remote Database Access
Hi can anybody know how to connect remote database with asp.net application? Actually my database is in different machine (in different server, different location) so i want to connect that server. Every time I'm getting the fallowing message
 
An error has occured while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.
Thank you,
Nagu

View Replies !
Connecting To Remote Database?
I am using SQL Server 2000 database in my VB.Net project.
My VB.net application is installed one two machines in different cities i.e. there are two separate databases.
First machine's IP address is say 202.33.44.55 and other machine IP address is say 203.33.55.66. Now I want to use each others databases i.e. I want to set their database group.
So that in my VB.Net's application which is installed on 202.33.44.55 I could see data of the 203.33.55.66 by just changing the connection string

View Replies !
Connecting To Remote Database Using EM
Hi to all:
I always had a problem connecting to SQL Server from home using EM.
I do add a new server registration, but i always get the following exception:

A Connection could not be established to IP ADDRESS
Reason: SQL Server does not exist or access denied.
ConnectionOpen(Connect())
At the same time, I do use a utility, found at http://sql.bhaidar.net to connect to the same database and works perfect.
Is there any configuration I should do to my pc, don't know maybe some port configuration or so, to allow EM to connect to those remote databases?
Thanks in advance.
Regards

View Replies !
Remote Database Connection
Hello,
 
My database stays in a remote site and I have access it through VPN. I would like connect my current Windows based Asp.Net application with this database. What are my options? Can I connect remote database with SqlDataAdaper, will that be slow? Should I sue Web Services to connect database?

View Replies !
How To Connect To A Remote Database ?
Hello,First, sorry for my bad English.Here is my problem:BoxA: XPpro + Apache + php (using php_mssql.php)+ ADOdb + MS SQL Server+ My_Prog (using local MS SQL PUBS database)BoxB: NT4 + Apache + php (using php_mssql.php)+ ADOdb + My_Prog (usingremote BoxA PUBS database)BoxC: W2KMy_Prog uses:$serveur = '10.0.0.1'; BoxA's IP address$admin_nom = 'sa';$admin_mdp = '';$base = 'PUBS';$conn = &ADONewConnection($sgbd);$conn->debug = true;$a = $conn->Connect ($serveur,$admin_nom,$admin_mdp,$base);From BoxC, using IE, connecting to:- BoxA My_Prog : I access PUBS, that's OK- BoxB My_prog : "Warning: mssql_connect(): message: Echec de laconnexion de l'utilisateur 'sa'. Raison : Non associé à une connexionsécurisée SQL Server. (severity 14) in ...adodb-mssql.inc.php on line438." (I prefer to report the "French" message)Anyone knows about ?Thanks in advance,Eric

View Replies !
Connect To A Remote Database
can anyone explain to me how to connect to a remote database thru the internet, am new to sql server

View Replies !
Remote SQL Database File
Hi,

We have 2 Windows server installed . A installed with Windows 2000 server with SQL server 2000 and B is installed with only Windows 2003.

We setup the SQL database on Windows 2003 using a control panel and the database will be setup remotely on the Windows 2000 server.

Is it possible so that the SQL database file to be placed locally on Windows 2003 server instead on the Windows 2000 server which has the SQL 2000 server installed?

Thanks,

View Replies !
Remote Database Configuration
Please excuse me as although I have lots of database design & development experience I'm not database administrator and I'm new to SQL Server.

I have a SQL server 7 database on a remote web server which I can access over the Internet.

I have SQL server 7 installed on my local network server and I use Enterprise Manager to administer and configure the databases on the server.

Can I use Enterprise Manager to administer and configure the remote database?

If I can't then how do I make changes to the remote database? Do I need to FTP objects or use RAS?

Any help would be very much appreciated?

View Replies !
Remote SQL Database Backup
Hello Everyone,

I got a problem when I tried to backup SQL 7.0 database to a remote location.
The situation isthat I have two SQL Servers (both are SQL Server 7), They are in the same domain, but in two different NT servers mechines. When I create a new backup device, I can only see the local partitions.

I tried to use T-SQL to create the backup device. It can create it, but when I tried to use it, I got a error message, saying the disk not exist.

I thought that might have something to do with disk sharing, but not sure. Can any of you give me some advice on how I can access the remote partitions from SQL's Enterprise Manager? Thank you very much!

Lunjun

View Replies !
HOW TO UPDATE A REMOTE DATABASE
Can someone help me, PLEASE:

How to update a remote sql server 7 database!

View Replies !
Remote Database Connections With 6.5
I have a need to connect to a remote (i.e. database on the clients site) SQL Server database from a live application. It is relatively easy under Oracle, but I havent tried to do to an SQL Server. Has anyone done this? The remote SQL Server database in question is 6.5
You can set up odbc connections to remote clients (99% sure on this) so you could go this way. You can also connect directly to a sql box through an IP address in sql7, but I am not too sure how it is with 6.5.

View Replies !
Connect To Remote SQL Database From LAN
Hi
 
I am trying to conect to a remote database using SQL Management Studio Express from inside a LAN but get an error message indicating that the server does not accept remote connections. However, I can connect with no problems from outside our LAN.  I am looking for suggestions on how to resolve this issue
 
Bob

View Replies !
Database On Remote Server
I've been reading the threads about using a mdf on a remote machine.

I've enabled TCP/IP and started the browser service as well as adding sqlserver.exe and sqlbrowser.exe to the firewall exception list.

I'm still unable to create/connect to a mdf using the data source wizard and that seems in line with the threads I've read.

I've found examples on how to write the connection code in my program but I'm still unsure about a couple things.

If I create the mdf on my local machine and then copy it to the remote machine, does    sql server express have to be installed on the remote machine or just the local machine? It seems like just having the mdf on the remote machine would mean that for multiple users to access the mdf, there would be several copies of  sql server trying to manage the mdf or do I misunderstand what is going on here?

Thank you

View Replies !
VB Cant' Access My Remote Database
Hi everybody

I have a remote SQLExpress instance running. I can connect to its databases with the SQL Server Management Studio Express and Visualstudio (Datasources) on a remote system and on a local system.

But as soon as I try to run or debug a vb application a system security error apears.

Thanks for you help

Ueli

View Replies !
Remote Connection To Database On Same PC?
I am running the SQL express advanced on the same PC that also hosts my Visual Basic Express application.  I have user instances turned off and full-text enabled and working from within a SQL query window.  However, I can not create a working connection to the database using the data source wizard from the server explorer within VB.NET.  Since this is on the same PC, do I need to enable anything other than shared memory?  I get the error: Provider SQL Network Interfaces, error 26 Error locating server/instance.

DeBug 

View Replies !
Cannot Connect To A Remote Database
I just installed the 90 day VS2005 Professional Edition  -  prior to this I was using VS2005 Beta 2  - 

I have a database on a remote server that I have been using in VS2005 Beta 2 with no problems  -  In VS2005 Beta 2 I succesfully ran aspnet_regsql against this database and set up connection strings in the Web.config file and everything ran fine.

Now after installing VS2005  ( I re-installed Windows XP Pro to make it a clean install - this has not been a short process )  anyway the same projects are not working in VS2005 90 day edition 

I get the error
An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

I tried enabling TCP/IP and named pipes in the server manager but no luck

thanks

 

 

View Replies !
Deploying To Remote Database
Hi,
We are using SQL-Server (2005) for the first time and have developed an app that uses 2 dozen tables and a bunch of SP, triggers, etc.
How do we get our entities to our client site without a lot of copying and pasting? How about the data we want to upload for lookup tables - how would we get the data there?
Moreover, how do we sync stored procedures with the live database as we make changes during development?
Thanks,
Mark

View Replies !
Remote Adminstrate Sql Database
Can I administrate database from client ?

I used to do this by using win remote-desktop to windows server 2003, but since the administrator's password had changed (for security reason), I can do that anymore.

The sys.Admin allow me to make changes in server room but I dont want them watching what I am doing, I may want to add some table, some field depend what users demand. what I have in my notebook is SQL2000 personal edition which cannot modify table's structure.

Any suggestion will be very appreciated.
Thanks

ps. sorry for my poor english

View Replies !
How To Backup Remote SQL 2005 Database?
I use SQL 2005 Database in my ASP.Net 2.0 site, I have to require admin backup db for me every time, I hope to I can backup by myself , how can I do?
You know  Microsoft SQL Server Database Publishing Wizard can restore DB easily!
Many thanks!

View Replies !
Update A Database On A Remote Server
I have a database on my web hosting site.  It is a sql server 2005 database that was created in sql server management studio express.
I can access this database in code using a connection string and do things like show results on my page.
However I now want to do things like delete certain records, or update stored procedure criteria, usually I would do this by running sql in management studio but as my database is now online with the hosting company how would I do this?
 

View Replies !
Accessing My MS-SQL Database On Remote Web Site
I've downloaded a copy of Microsoft SQL Server Management Studio Express from MS. Can this product be used to query an SQL database at a web site.
Conversely, is there a command line utility for running SELECT statement queries on my remote web site database?

View Replies !
Remote Aspnet Database Access Help
I have my normal SQL 2005 database....and another database (on the same machine) that is the default aspnet database. I use that for authentication of course. Everything is working well except now I need to (for a SP I'm creating) access the UserID field in the Users table (without the customer logged in). I know this isn't the best way to do it but....Can someone tell me how to programatically (from an existing SP) access the aspnet database? So I can just check something against the UserID (providerkey) I already have? The customer isn't logged in at this point. I have their UserID from somewhere else. Here is what I am trying to use now. IT Works in Query Manager but throws an error (...in this security context) when I run it in ASP.NET...SELECT @UserName=(select UserName from  [aspnetdb].dbo.aspnet_Users where UserID=@UserID)   Thanks. 

View Replies !
Remote Database Connection --SQL Server
 HI   I have installed VS 2005 with that SQL express edition came default and i then installde SQL server Enterprise Edition .....There i created database and tables and other my colleagues are not able to connect to the Database from there System...........I am using This on XP.......Is it possible to access databse from other remote systems .....IF yes What is the procedure to connect from my other computer to my database which is on XP not any Server OS..  

View Replies !
Connection To Database On A Remote Server
Here is my environment and problem:
 I have VWD 2005 and SSE 2005 installed on my local machine. I also have these installed on my Windows 2003 Server. I developed my database using SSE on my local machine but pointing to directory on my server. I have been developing the web app using VWD on my server. I now want to use VWD on my local machine and point to the project on my server. I am able to open the project. In order to access the database in the "Database Explorer" I use as my "Data Source", "MS SQL Server (SQL Client) and it attaches fine and I can see my tables and data.
 Now for my problem:
When I try to run the application "VIew in Browser", which login.aspx page is my first page, I get the page, but it doesn't inherit my master page which has the basic navigation and layout. Then after I try to login I get this message.
The file "W:BBAppApp_DataTimeTracker.mdf" is on a network path that is not supported for database files.An attempt to attach an auto-named database for file W:BBAppApp_DataTimeTracker.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
Here is a portion of my web.config file for the connection string.<connectionStrings>
<remove name="LocalSqlServer" />
<add name="LocalSqlServer" connectionString="Data Source=.SQLExpress;Integrated Security=true;AttachDBFilename=|DataDirectory|TimeTracker.mdf;User Instance=true" />
My website I started with the source code for the TimeTracker start kit and have added more pages and changed the sitemap.
In general I guess I need to know how to handle using VWD on my local machine, but accessing the project on the server. The reason I'm doing this is because my colleague needs to be able to access the web app too to add pages to the site.
 Thank you for any help.

View Replies !
How To Update SQL Database On Remote Server?
Hi,
I'm using "Microsoft SQL Server Database Publishing Wizard" to import and create database on a remote server.
Is there a convenient tool to update SQL database on a remote server to match with database that I have on my computer?

View Replies !
Upload Database To Remote Server
I have a database on my local system and I use Sql Server 2005 express.  Now I need to upload the database in the hosting server. I have tried Management Studio Express.

View Replies !
Best Way To Create A Remote Database And Data Within It?
Is there any tool that will allow me to create a script for creating a database with all its objects like triggers, indexes, relationships etc. and also populating the tables with data ? So far I haven't found any.

View Replies !
Remote Access To Sql Database...permissions
Hi all,I need some help to access an SQL db on another machine. I am using VB.NETand remoting to make a client/server connection...although I don't thinkthis is relevant to the question.I have been asked to help with a small db project that will reside on ouroffice server and have approx. 5 users.I have installed a copy of MSDE on my development machine and plan on doingthe same on my office 'server'....in fact it may well already be on there. Ialso have another testbed to act as the client.Because I don't really know what I'm doing...........I have copied the dbcreated on my client to the server. I have done this by 'cheating'. I usethe VB.NET IDE to create the correctly named db under the sql server. I thengo to this file in windows explorer and write over it (and the .LDF) withthe file from the client.When I try to connect to this db remotely I get a fail to connect errorabout not recognising 'localmachinenameguest'...sorry, not the exact errorwording. I can provide this if it will be helpful.Can anyone point me in the right direct?I don't have any sql/db tools other than anything that is included with MSDE(which I don't think is much).I will be posting other Q's for any experts out there!Thanks in advance.Phil

View Replies !
How Can I Administer SQL Database On Remote Web Server
Hello EverybodyPlease tell me which is the best method to adminster SQL Serverdatabase in remote web server.Eg. I am storing all the information of SQL database in my work placeand after that have to upload the modified table to remote web server.Please tell me what is the easiest way or how I can achieve thiswithout purchasing third party applications.With regardsBabu Thomas

View Replies !
Best Way To Install A Database At A Remote Site
Greetings,I am in the process of installing a SQL database at a customerlocation. I have determined that there are 3 ways to do this, and Iwanted to know which is the best of the 3.1 Install From Script.In this method I create the database and its objects in scripts thatare run via osql utility on the SQL server machine. For loading anyinitial data that I need in the database I also run bcp commands.2 Install from a backupIn this method I created an empty database on the SQL server, and thenrestore over it the database from a backup of the database that I needto deploy. Then I add or re-attach the users for the database. Iperform all of these operations using osql as well.3 Install by attaching the data files.In this method I created an empty database on the SQL server, and thenI attach the data files to the database using the sp_attach procedure.Then I add or re-attach the users for the database. I perform all ofthese operations using osql as well.Although it is no problem for me to use any of these methods, I wantedto know from you veterans out there what the best practices are. Andalso if there are any unseen hazards for each method above. Or if Iam totally off-the-target, and there is another method that is thepreferred way.Thanks in Advance,roger

View Replies !
Hosting An SQL Database On Remote Share
Hi,
I would really appreciate help with this query.

I have an SQL 2000 server setup with 2 databases. My boss would like to setup another database but wants the actual database to reside on a different server share.

Is is possible for one database on an SQL server to be hosted on a remote share ?

appreicate any info
thanks

View Replies !
How To Access The Remote SQL Server Database
Hello SQL guys,

If possible to connect our remote server from my end ?.what r the possiblities is there.tell me some ideas,i already tried it to register our remote server database thru ODBC but it not connected properly but i ve tried in our intranet/network it's working fine.

Nellai

View Replies !
Inner Join Using A Query On A The Same Remote Database
I have an sql 7.0 server. I need to run a query on a remote oracle server then take that output and inner join it with another table on the remote oracle server... then I need to put it a table in a database on my sql server... Anyone know how to do it? Help would be greatly appreciated...

View Replies !

Copyright © 2005-08 www.BigResource.com, All rights reserved