It is more common to set up a view on Sybase and use a linked server from SQL Server to connect to Sybase and import the data. Or you can...

Yes the report would have to be the key, what is the query it runs, what type of report is it (things like Crystal Reports have extra stuff they can...

I don't believe you can do the second option, but I have never tried. We use DTS in some situations to move the data to a common database and table....

To save a DTS package open the package in EM DTS Designer, then choose files Save As and you will have an option to save to VB file.

"Don't roll your...

It is hard to say if this is a poor or good query as there is a lot of work especially on the subquery join. Which means usually you will...

Here is a good list of the values from SELECT @@version to tell yuo th SP level.

http://www.sql-server-performance.com/service_packs.asp

"Don't roll your eyes at me. I will tape them in place." (Teacher on...

Glad to hear, duplicate message see responses in http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=5463&FORUM_ID=8&CAT_ID=1&Topic_Title=can+you+UPDATE+with+a+self+join&Forum_Title=T%2DSQL%5B/url as well.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Depends on you situation and yes you can see blocking. Look at each in SQL BOL and they will tell you. UPDATE STATISTICS stats can be used in place of...

Yes an update this way is quite common. If you want to test without affecting your data you can do

SELECT * FROM table_x

BEGIN TRANS

YourUpdate Here

SELECT * FROM table_x

If it looks...

I have had not problems with Oracle, DB2, INFORMIX and SQL. I will take a look and see if anything else could be involved and let you know when I...

Turning Auto Update Stats and Suto Shrink on and off does not always perform the action as expected, especially Auto update stats as it is based on percentage of change...

FIrst try the action of the change thru EM Table designer to be sure it is not something about your syntax (if EM doesn't work the problem is bigger). Also...

Use sp_detach_db to detach the mdb file if still attached, then use sp_attach_single_file_db [ @dbname = ] 'dbname'

, [ @physname = ] 'physical_name' to reattach...

What version of SQL and SP are you running? If 7 and SP 1 or no SP then try SP2 or better, I believe there was a known issue that...

To stop

NET STOP MSSQLSERVER

or if you are also running sql agent (It will ask if you want to stop related services the /y answer that without user input)

NET STOP MSSQLSERVER...