Another way is, open Enterprise Manager, connect to the Server, Database, Table. On right hand side, select/highlight the table whose attribute you want, Press CTRL+C, come to Query Analyzer...

In query Analyzer first highlight/select the Table, then click {ALT} & F1 together

paul

I try to keep alias names consistent across all the SPs / Views / Triggers

Table Aliases

=====================

Area ...

"srvinfo" never worked for me. Am I missing something?

paul

Can you say

Select * into #MyTempTable

Exec MyProcName @Param1, @Param2....

paul

Try this SQL

1. DUMP TRAN <DBNAme> with no_log

Backup the database after this.

2. Did you try Dbcc Shrink file>

paul

look for "OBJECTPROPERTY" in Books on-line

paul

Here are some solutions 🙂

==============================================================

How can I shrink the transaction log in SQL Server 7 and 2000?

==============================================================

http://www.sqlservercentral.com/faq/viewfaqanswer.asp?categoryid=2&faqid=154

http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=26&CategoryNm=Maintenance%20and%20Management%20&CategoryID=1

http://www.sqlservercentral.com/scripts/contributions/666.asp

Soln1 - Have you...

Sorry if I sound stupid, but here is another simple solutions.

Export from Access to Excel, the Excel to SQL.

paul

You can do one thing, check if the Link Server connection is Active, if not EXIT gracefully from your Stored Procedure

You might want to see the section "Testing the link"...

I got this information from somewhere, but have never tested it. Hope this will help you.

==============================================================

How can I shrink the transaction log in SQL Server 7 and 2000? ...

SIMPLE SQL COMPARISON and SYNCHRONIZATION TOOLS

===============================================

--SQL Compare - for comparing and synchronizing database structures.

--SQL Data Compare - for comparing and synchronizing...

See if this helps.

http://www.swynk.com/friends/boyle/linkedservers-1.asp

http://www.sqlservercentral.com/columnists/awarren/addinglinkedserversusingsqldmo.asp

paul

See if this helps.

http://www.sqlservercentral.com/faq/viewfaqanswer.asp?categoryid=2&faqid=154

http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=26&CategoryNm=Maintenance%20and%20Management%20&CategoryID=1

Soln1 - Have you tried running DBCC SHRINKFILE with first the NOTRUNCATE option to move all the data to

...

Hi Antares686

Do you have the URL for that site please 🙂

paul