Viewing 15 posts - 286 through 300 (of 349 total)
Hello Howard,
Are you sure that you have the .mdf file. B'cos in the syntax you are mentioning the .mdf file but the error is pointing that .ldf file is incorrect.
Please...
January 30, 2006 at 10:17 am
Hello Stefan,
Do you find any information in SQL Server Logs or Event Viewer?
What does the stored procedure do?
If you can provide more information, then we can go ahead investigating it...
January 30, 2006 at 9:22 am
Hello Howard,
Yes, you can attach a database with .mdf file but you will loose all the transactions, which have not been committed to the database.
SQL Server will create a new .ldf...
January 30, 2006 at 8:52 am
Hello Robert,
Go through Books Online -> Scope_Identity.
It has a detailed explanation with an example of how Scope_Identity and @@Identity works.
Thanks and have a nice day!!!
January 30, 2006 at 8:43 am
Hello David,
When you define a primary key on a table, the entity integrity is enforced on the table.
In Books Online:
A table usually has a column or combination...
January 27, 2006 at 9:49 am
Check in Books Online for the syntax of "isql". According to it, modify your .bat file contents and execute the same.
January 26, 2006 at 3:53 pm
Hello Dave,
Can you modify your .bat file according to the "isql" syntax and then execute the same?
Thanks and have a nice day!!!
January 26, 2006 at 3:46 pm
Hello Greg,
To identify which hostname is using the SQL Server, you need to select the "HostName" under the Data Columns (3rd Tab). This information will be trapped if and only...
January 26, 2006 at 12:36 pm
Hello Bill,
Go through this link
you will find the details.
Thanks and have a nice day!!!
January 26, 2006 at 11:55 am
Hello Betty,
You have defined the column to have the default value of "getdate()" in the table structure. Then why are you again accepting the date as input in the stored...
January 26, 2006 at 11:53 am
Check "Replace" string function in BOL.
January 26, 2006 at 10:18 am
Hello Miquel,
You can define a workflow "On Success", so that based on the existence of records, it will proceed to the next step in the DTS package.
Thanks and have a...
January 26, 2006 at 8:32 am
Hello Carlos,
I'm not sure b'coz I'm at the initial stages on SQL Server 2005.
Go through this link, may be it gives you the required solution
http://msdn2.microsoft.com/en-us/library/ms140355.aspx
Thanks and have a nice...
January 26, 2006 at 7:31 am
Hello Donald,
Please check one of the earlier threads posted on this site
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=117030
Thanks and have a nice day!!!
January 25, 2006 at 2:30 pm
January 25, 2006 at 2:23 pm
Viewing 15 posts - 286 through 300 (of 349 total)