Viewing 15 posts - 5,236 through 5,250 (of 7,429 total)
First are you sure it was deleted from the sysobjects table. This is not normally possible unless you reconfigure the server to allow system tables to be updated. I ask...
July 15, 2002 at 7:33 am
Can yuo tell me a bit more about the remote database. Is it SQL Server? ALso post the details of how you set up the remote connection. And the query...
July 15, 2002 at 7:10 am
However going back to your statement and adding to what was stated. The query engine uses your conditions against the indexes on the database to meet you criteria. If like...
July 15, 2002 at 6:50 am
However based on what you stated
quote:
I dont have any scripts or backup of the database
July 15, 2002 at 6:29 am
Short of reinstalling SQL server check here http://msdn.microsoft.com/downloads/default.asp?URL=/code/topic.asp?URL=/msdn-files/028/000/123/topic.xml for the Meta Data Services SDK which includes the repository engine. Only problem is looks like someone at MS is fooling with...
July 15, 2002 at 6:18 am
Just keep in mind that a trace is the only way you will see SELECT, TRUNCATE and other nonlogged style functions.
"Don't roll your eyes at me. I will tape them...
July 13, 2002 at 2:02 pm
These are configurable both at the server level for default and the individual users based on language otherwise DATEFORMAT allows specific formats for entry. To set at the server level,...
July 13, 2002 at 2:00 pm
I agree with that change. Hard to always come up with the right statement exactly.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
July 13, 2002 at 11:31 am
Not sure what you mean. When you create the flash presentation and compile it you load it with the appropriate object tag in HTML (or HTML in ASP). To find...
July 12, 2002 at 11:01 pm
you need to pass as a char/varchar like this
SP_DB_BACKUP eCommerce, 'E:\SQLBackup'
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
July 12, 2002 at 10:55 pm
Sounds good. Thinking maybe there is a configuration issue on you machine but it would seem more like it is the SQL server but as you said runnign from another...
July 12, 2002 at 10:51 pm
The also could be some sort of time division difference that could be the cause. I am not sure as I have not tested, but I believe the data is...
July 12, 2002 at 10:42 pm
In a clustered scan the data is read sequentially from the top until the actual data is reached. You will tend to see these with likes. However a seek utilizes...
July 12, 2002 at 10:37 pm
Look at you execution plan in QA or use SET SHOWPLAN_TEXT ON and see what the query engine is deciding is the best access method. Sometimes it can be as...
July 12, 2002 at 10:32 pm
Glad I could help. I enjoy these kinds of things and have found reading showplan is the best way to get an understanding how to improve performance. My suggestion is...
July 12, 2002 at 10:27 pm
Viewing 15 posts - 5,236 through 5,250 (of 7,429 total)