create a unique number with date (year)!?

Hi, i work with sql server 2005 and i 'm a beginner ! i have a table as this : demandeId => int ide…

Difference between Online DBCC Operations & DBCC Operations

Hi, Is there any difference between Online DBCC Operations & DBCC Operations?

Foreign key and SSIS

Hi, I have to populate a table(table1) from flat file. One of the fields is foreign key i.e. it ref…

Move the data from SAN(old) to new SAN

Hi, I want to move the data from SAN(old) to SAN(new), but I am running replication, see my isssue …

Can we ran DBCC CHECKDB on Secondary databases in Log shipping:

Hi, We have configured Logshipping in SQL Server 2005. In our secondary server, the hard disk has f…

Two log files consolidation

Hi Guys, I have two T-log files for an existing database. How do I consolidate these 2 log files in…

Select query on sql2005 takes 15 times more than Sql 2000

Hi All, The below query takes only 0 seconds in mssql2000 but it takes 15 seconds in mssql 2005 whi…

How to read only particular fields from flat file into the database in ssis

Hi, I have one flat file having number of columns(45) in that i have to filter the columns i.e, 10 …

DB Backup aborted

Hi All, PLease help me to resolve this eeror SQL server 2008 SP1 Whil etried to get backup for the …

Database Mirroring and Maintenance Jobs

Hi, We have a situation where in the DB needs to be 24 * 7 through out the entire week, there by e…

Synonym+Identity

I have created synonym for inseting data into some table. But that table has identity column. So t…

Export CSV to HTTPS - "web folder" with SSIS 2005

Hi All, We have a clinet that wants us to send him his files directly to his Web-Folder. the desire…

Generating dummy test data - Test Data Generator

Hello, I am trying to generate test data (small set) for our databases. What is an easy way to do s…

Java script

select to 2 resords for each record

Hi all, these is my result bu i want result ID count 1 10 1 20 1 30 1 …