Viewing 15 posts - 481 through 495 (of 707 total)
Gud question. I had forgotten abt incremental value as I never use it. I always increment identity column with default value.
October 28, 2009 at 10:45 pm
Don't know if I understand what exactly you want.
Insert InTo tblCUSTOM281009(iSalutation )
SELECT iSalutation
FROM dbo.tblCustPerson
Inner Join dbo. tblCUSTOM281009 On dbo.tblCustPerson.iCustID = dbo.tblCUSTOM281009.icustID
order by dbo.tblCustPerson.iSalutation
October 27, 2009 at 11:29 pm
First of all don't panic. Cool down. There are many experienced SQL experts here in this forum. They will give you a proper solution.
I think you can stop SQL Server...
October 26, 2009 at 11:26 pm
[you made my day,Exactly I should not have the period infront of bak file.
I am specifying as .bak
Haaa...gud. Whenever we do something new we gotta check everything left and right....
October 26, 2009 at 11:19 pm
Yeah...If it's 32 bit you will have to enable AWE option.
In 64 bit it's not necessary.
October 26, 2009 at 11:13 pm
how can we copy one database table to another DB table without script and insert statement?
You mean you want to copy data from one DB to another.?
Is the table...
October 26, 2009 at 11:10 pm
It doesn't leave the DB in the offline state, doesn't put it online. In fact (if you check the sys.databases view) the state of a DB after doing this is...
October 16, 2009 at 3:39 am
If you leave out either step 1 or step 3, the DB will be suspect when it's brought online.
Gila, Infact it's not coming online at all. Getting the error saying...
October 15, 2009 at 11:16 pm
make sure you use alter database modify file command between offline and online so SQL knows the new name of the file. Otherwise database won't come back online.
Sorry !...Missed this...
October 15, 2009 at 11:04 pm
Tara-1044200 (10/15/2009)
1. how do i rename mdf and ldf file names of a database without restoring or creating new database and move the data ?
Take the database OFFLINE. Go and...
October 15, 2009 at 7:46 am
Can't you add a "Maintenance Cleanup Task" and delete those files..?
October 13, 2009 at 5:44 am
Thanks a ton bitbucket. Was expecting such replys.
Started doing all these. Planning to attend MCTS exam within 15 days.
SQL Experts...any other suggestions/links ?.
Once again thanks a lot.
October 11, 2009 at 11:02 pm
Books online is your friend in this matter. Even if you have huge database you cannot replicate the real time environment. There are lot to learn other than performance...
October 9, 2009 at 7:26 am
1.Master_Market
2.Master_Product (FK to Primary of Master_Market )
3.Master_Model (FK to Primary of Master_Product )
but user will be selecting Master_Model level info, i am saving Master_Model internal id (PK) into database.
There's nothing...
October 5, 2009 at 10:46 pm
Viewing 15 posts - 481 through 495 (of 707 total)