Here is my setup. 3 sql servers.
Publisher: sql 2000
Distributor: sql 2000
Subscriber: sql 2005
Publisher can push the data to the distributor. A snapshot is generated successfully. Howe...
How do i take the System Date (@DATE) and convert it to CCYYMMDD.
We were running WSS 3.0 and decided to move to MOSS 2007. I tried an in-place upgrade and had countless problems. I now decided to instal MOSS 2007 alone and it runs fine. How do I migrate my ...
Hello I have a Sql problem that i hope you can help me out with.
I have a Live SQL 2000 DB and a Test SQL 2000 DB. I have been tasked with making a nightly copy of the Live DB and restoring i...
This PC has a ton of ODBC connections set up. IS there a way to make a copy of them and then load them on my new pc?
I have a table with these fields:
Ticket
User
Score
Date
The score is either passed or failed. I am doing a count based on passed or failed grouped by user and date. The result is a col...
I need to calculate a percentage from a single table.
I need to get a count of records whose status is set to closed and divide that by the total records but grouped by another field in th...
I am trying to backup my databases and it is appending it to the .bak file...I would like it to overwrite the file each time it backs up. Here is what i have in my .bat file:
sqlcmd -S THE...
dear all i need to create my special report iam using crystal report 7
using ado with vb6 programming
the problem
i have table with this fields
tbl_saleman ( salesman_name , itemc...
What is the difference between sql,sql/pl,sql server and sql databaser?
I am trying to select some data between some tables and one of the columns is a date field.
I would like to add a "Where a.update_date is yesterdays date)"
i have tried
where a.update...
hello experts,
i have an issue..i have 2 tables
one is agents
Name Null? Type
AGENT_ID NOT NULL NUMBER(8)
FIRST_NAME VARCHAR2(50)
LAST_NAME VARCHAR2(50)
CODE_NAME NOT NULL ...
How to compare two Databases and insert/update one having the lesser information.I tried using dataadapter.update/insert but to no avail.How can I do that?
I have three more tables related ...
I have a field called myCats which has comma delimited values such as:
1,2,3,4,10
1,2,3,5,6
1,4,6,6,6
How do I query the myCats field for a select value in the string?
SELECT *
FRO...
My collegue deleted a company in sage via drive explore. He then tried to do a system restore to retrieve the lost data. However I have now done a scan of the drive and have managed to recover...
We have a table in sql server 2005 and while trying to insert more than 12,500 characters in the column with data type varchar. But it not allowing to save more than 12,500 characters. Please ...
I used to have my SQL 2000 database on a celeron based server so we moved the database on a quad core server with a lot more memory than the celeron based server. For some reason the database ...
I have created a small tbl in a sql database. I know every record also exists in a bigger system table. I am trying to pull the data from the big table as there are extra fields in there I ne...
I use SQL Express 2005 and Server Management Studio Express.
When I use dbo as a prefix to a table name, does that mean Data Base Object? If not, what does it mean?
And what's the scope...
Hi there,
which is the fastest way of millions of data from different tables into one table???I am using SQL 2005
I need the user names from a cloumn of email address. All the fiields are user@gmail.com, I want to get rid of all the @gmail.com, and just get the user names. so I have:
mike@gmail.com
...
I would like to schedule some DBCC commands and have the output written to a file for future reference. I've been trying to use bcp and not having much success.
DECLARE @FileName varchar(15...
What do the experts here think are the most important things to consider and/or ask prior to data migration?
really simple one here that i should know but for some reason cant get to work
im trying to run the following sql
UPDATE tbl SET field = field + 1 WHERE otherfield = param
but it d...
I have a client running a program using SQL2005. They are getting sporadic error msgs that the software vendor is actively working on. In the meantime they are getting these errors which cause...
