no u don,t have to need to give the extension of the file Saleem Hakani <hakani_saleem@...> wrote:It's okay if you don't give an extention to the backup...
854
edazwork
Apr 11, 2005 4:56 am
We have a situation where someone created multiple MDF files for a database and we'd like to combine them into one large MDF file. Has anyone been able to do...
853
Santhosh
san_spy
Apr 11, 2005 4:56 am
Hi aaditya, try this sneaky procedure out...run this procedure and it will print the results in the query analyser u can copy and use it.. the table structure...
852
ciaofromluca
Apr 11, 2005 4:56 am
Is it correct to assign the extension bak (*.bak) to a SQL Server backup? Is this the right extension for a SQL Server backup file? Thank you Luca ... ...
851
Saleem Hakani
hakani_saleem
Apr 11, 2005 4:56 am
Aaditya, let me get this straight: You have several tables in a database and are trying to script all the objects "BUT would also like to generate Insert...
850
mohan mareboina
govinda_junior
Apr 11, 2005 4:56 am
Hi Uma, Hope this article helps you more understanding of how detect and resolve deadlocks: http://support.microsoft.com/default.aspx?scid=kb;en-us;832524 ...
849
mohan mareboina
govinda_junior
Apr 11, 2005 4:56 am
Hi Luca, Extension is not mandatory. You can give your extensions .bkp or .dat, its up to you. MS recommends .bak extension. Here is my example, may be helpful...
848
JeeLani bASHa
basha_21_99
Apr 11, 2005 4:56 am
Hi group, Im n a deep trouble, one of my db user has deleted some records from the database since there was a cascading delete enabled on the table we have...
847
sqlcon@yahoogroups.com
Apr 9, 2005 6:10 pm
Reminder from the Calendar of sqlcon http://groups.yahoo.com/group/sqlcon/cal DevCon 2005 Sunday April 10, 2005 All Day (This event does not repeat.) Event...
846
veer wangoo
vwangoo
Apr 6, 2005 1:44 pm
Thanks a lot everybody.Actually I was not facing this issue..But somebody mailed me this problem and she/he was member of SQLCON ..hope he/she has got the...
845
Saleem Hakani
hakani_saleem
Apr 6, 2005 1:44 pm
It's okay if you don't give an extention to the backup file as when restoring SQL Server understands that it's the backup file just by reading the header...
844
Saleem Hakani
hakani_saleem
Apr 6, 2005 12:34 pm
Veer, Q1) Are you running MSDE 7.0 / MSDE 2000? If Yes than please follow this article: For MSDE 7.0: http://support.microsoft.com/kb/246815/EN-US/ For MSDE...
843
Gem Tgs
onlytgs
Apr 6, 2005 12:34 pm
Hi Anjana Thanks for the Mugh invitation and its DEVCON 2005 information. I'd like to participate in this valuable session but presently I'm at Kolkata for my...
842
Saleem Hakani
hakani_saleem
Apr 6, 2005 12:33 pm
Raja Shekar, You can do all the but you will still be missing the data for which the dates are not compatible with the destination table, therefore the best...
841
Biswajit Das
radhye
Apr 6, 2005 12:33 pm
Hi aaditya why you dont try bcp commnad. is the data in the text format.if then try to use bcp commnad it automatically transfer the data from txt to the...
840
ciaofromluca
Apr 6, 2005 12:33 pm
Hi In the SQL Server Backup window (Enterprise Manager/Database/All Tasks/ Backup Database)/Destination section if I decide to back up the database to a file...
839
Anjana Ram
anjana_r21
Apr 5, 2005 12:25 pm
MUGH (Microsoft User Group Hyderabad) cordially invites you all to DEVCON 2005. You can register online at http://www.mugh.net/devcon This is a Full Day Event...
838
CHK
harish_c_99
Apr 5, 2005 10:53 am
On Mon, 4 Apr 2005 12:20:02 +0530, "Roji. P. Thomas"...
837
subhashini_simha
subhashini_s...
Apr 5, 2005 10:52 am
Write & Win! With the MSDN Magazine APAC Series Article Writing Competition Great software developers help to make great applications. But how do we foster and...
836
Roji. P. Thomas
roji_pt
Apr 4, 2005 7:25 am
Veer, Its hard to suggest a solution without knowing what exactly the job does. Still a fgew things to try... 1. copy the SQL statements to Query Analyser and...
835
Roji. P. Thomas
roji_pt
Apr 4, 2005 6:38 am
http://www.sql-server-performance.com/deadlocks.asp Regards Roji. P. Thomas ... From: Gomathi To: sqlcon@yahoogroups.com Sent: Wednesday, March 30, 2005 11:08...
834
veer
vwangoo
Apr 4, 2005 6:37 am
Here is an other way to avoid Deadlocks...as shared sql SErVER performace people... Tips for Reducing SQL Server Deadlocks Deadlocking occurs when two user...
833
Roji. P. Thomas
roji_pt
Apr 4, 2005 6:36 am
Here is a stored procedure by Narayana Vyas, which will generate INSERT statements for existing data. http://vyaskn.tripod.com/code/generate_inserts.txt ...
832
veer
vwangoo
Apr 4, 2005 6:34 am
One of the users sent me this mail ..I thought of opening it to group... He is executing a JOB on SQL SERVER AGENT and getting following error Executed as...
831
Roji. P. Thomas
roji_pt
Apr 4, 2005 6:34 am
Here is the official introduction. http://www.microsoft.com/sql/reporting/productinfo/overview.asp Regards Roji. P. Thomas NetAssetManagement ... From: s a To:...
830
viswamitra.chevendra@...
mitracv
Apr 4, 2005 5:37 am
Hi, Deadlock occurs when two different connections try to acquire a lock on the other's resource without releasing a lock on their own resources. This can be...
829
viswamitra.chevendra@...
mitracv
Apr 4, 2005 5:37 am
Aaditya, You can write something like this. (this needs modification, I am just giving an example) For a table with three columns, first two integers and the...
828
Gomathi
umanilakantan
Apr 4, 2005 5:01 am
Hi, In one of our customer's site at the time of saving a transaction they hve encountered the following error: [Microsoft][ODBC SQL Server][SQL...
827
Aaditya Tarhalkar
aadityasqldba
Apr 4, 2005 4:59 am
Hi, I am trying to create a script file for creating all the database objects and want to include some insert statements of master data along with the those...
826
s a
anwarsql
Apr 4, 2005 4:59 am
Hi frenz could anybody tell me the detailed introduction about Sql Reporting Services. take care bye ... Do you Yahoo!? Yahoo! Small Business - Try our new...
