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...
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...
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...
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...
Here is the official introduction. http://www.microsoft.com/sql/reporting/productinfo/overview.asp Regards Roji. P. Thomas NetAssetManagement ... From: s a To:...
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...
Here is a stored procedure by Narayana Vyas, which will generate INSERT statements for existing data. http://vyaskn.tripod.com/code/generate_inserts.txt ...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
sqlcon@yahoogroups.com
Apr 9, 2005 6:10 pm
848
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...
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...
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 ...
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...
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 ... ...
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...
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...
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...