Microsoft SQL Server Forum

Please, I'm using two sql database servers (2008) on a network. Data is updated every minute and would like to synchronize the two servers so that backup can be taken from Sever1 to Server 2. Could some one show me the steps? Thanks. Ben

We have 10 million files and over a terabyte of data and it's still growing. We need to retain everything. Has anyone ever had to absord an entire File Share into Sharepoint? I figure I could either set up an enormous database which is scalable or I could do a filestream or possibly create a custom Sharepoint app that utilizes the filestream....

Hi, I hope someone can help me. Everything works fine with this code except it won't update the recordset. Any thoughts? I've done about everything I can think of and can't find any help on the Web. Private Sub cmdUpdate_SortOverall_Click() Dim Sqlstr As String Dim OSS As Integer, Diab As Integer, CVD As Integer, HT As Integer,...

i am using ms sql server express edition 2005. on the startup it asks for 'servername' to connect the server. how i got the servername when i want to run the queries on my pc only

This might be hard to explain what I am going for, but i will try. Ok, I have two tables: (1)"ZIPS" which contains zipcodes,states,and counties for everywhere in the U.S. and (2) "UserCriteria" which contains username, state, county, rank, and a few other criteria. In the UserCriteria table, I can have one user (mtaylor) representing many...

Hi. Have an ACCESS front end and SQL Server back end. Need to start redesigning the back end but folks still need to be using the DB. What is my best bet for a test environment? I was thinking SQL Server Developer Edition. Throughts would be appreciated. Thanks.

Basically, I need to find the department which consists more than 10 staffs as I am stuck. SELECT dname, sid FROM dept INNER JOIN staff ON dept.did = staff.did WHERE ?????? (this is the part where I am stuck) Any SQL will be helpful. I will frequently monitor this question to reply to ur answers and questions if u need it. Thanks in...

I have two stored procedures one for INSERT and second for Update and I'd like to merge them in one so could you please tell me which satement should I use for that ? CREATE PROCEDURE Tools (@CategoryID_1 int, @CategoryName_2 nvarchar(100), @Description_3 ntext) AS INSERT INTO Categories (CategoryID, CategoryName,

i have a table with following columns destination next hop and distance i have two rows with same destination number but different distances i want to use the next hop of the destination whose distance is the least

EXEC master..xp_cmdshell 'BCP "'select * from tmp_ACS_MultiDimensional where cName = 'CH All Workstations''" QUERYOUT D:\Test\MultiDimensionalReports\EMEA\SMP7_3741\CH_All_MultiDimensionalReports.xls -T -c' Is the command will work, can you please provide methe exact bcp command to execute..:)

SP_MAKEWEBTASK system procedure avilable in sqlserver 2005?is there any equalent procedure/scenario avliable in sql server 2008? Thanks in advance :) Reddeppa G

I have one table Products with 10 columns on which need create trigger(s) to update changes in data in another table Products_audit which has 10 same columns plus two additional columns "Date" и "User" where need to insert date and name of user who made changes.

Hello guys, I have one table Products and a second Products_audit with two columns User and Date. I need to have trigger which performs following actions: When anybody will modify data in Products, I need trigger to insert the User's name and Date of inserting into the Products_audit in appropriate columns. I wrote following: CREATE...

Hi guys, please help me with following: I have table "Products" and have following task: Count evarege cost and update cost of all products in column "UnitPrice" with conditions if current price > everage then -10% if < +20% By the way need to use variables Please help me to write script I use SQL server 2000 Thanks everybody before.

Firstly I want know that can we restored the deleted record back to its orignal place some column having the unique identity if yes then how.. ? and i tried this i search in web i found this the data is geting bak in hexa form ... even i cant able to convert it to normal form....... SELECT FROM sys.fn_dblog(NULL, NULL) WHERE ...

hi ... iwant to know how we can see the hidden table and procedure in the database.. actual i got a db but some procedure is not being seen so i want to know how we can see that hidden procedure .. that db is not created by me.....?

ow to fetch the data from one server to another server that are connected through lan. ...... Help me out

i have two tables 1.table of videos which looks like VideoID int VideoTitle varchar(max) Videodescripton etc... and second table Comments which has CommentID VideoID Comments etc.. now i want to get top 5 latest videos ids from the comments table how i will do that.. by using distinct is not the solution..

how can we get the result of the quries in all boxes such as in database there is name and id so i want that after select * from table the results will show in both the boxes name and id respectully can any one help??? am working with this type of coding Imports System.Data.SqlClient Public Class Database Dim strCON As String = "Data...

I'm trying to add a data source to my computer through the ODBC Data Source wizard. However, I keep getting an error that says Connection Failed: SQLState: '01000' SQL Server Error: 2 ConnectionOpen (Connect()). Connection Failed: SQLState: '08001' SQL Server Error: 17 SQL Server does not exist or access denied I'm running SQL Server...

sql statement for viewing table constraints

I would like to update only a specific year of a date field e.g year(exp_date) = year(2013)

How to convert the following SQL-C# logic to syntactically-correct SQL code (SQL Server 2005)? "Description", "LeaveType", "MonthlyMaxLeave", "YearlyMaxLeave" are the column names in the table EmpTab. I have written a basic logic to calculate the PayLeave and NonPayLeave, and to display its final values. Assume that the fields "Description"...

Can MSSQL do what foxpro did in terms of record locking? if so? How?. Tnx

I am trying to insert 100 rows in a single queries into the table. my table is CREATE User (ID INT IDENTITY(1,1)) Thanks in advance.