Viewing 15 posts - 1 through 15 (of 16 total)
try execute this command from the query analyser
Select * from linkedserver..databasename.table_name
or linked servername.databasename.dbo.tablename.
if u able to get the result set, then u can use the same in the stored...
May 24, 2005 at 10:40 pm
You can try using linked server concept.
i.e., create the list of servers which you want to access in the linked server and then you can pass that server name...
May 24, 2005 at 10:20 pm
Thanks for your reply.
I want to know how SQL server internally handling this number, does they have any system table? (like sysobjects,sysindexes,etc.,)
June 1, 2004 at 8:35 pm
May 26, 2004 at 1:27 am
Thanx for your inputs.
May 25, 2004 at 7:22 pm
You can use the dynamic properties task to define the txt file dynamically?
May 18, 2004 at 10:11 pm
check this out!
May 18, 2004 at 3:26 am
Thanx for ur suggestions. Let me check with him.
May 13, 2004 at 8:10 pm
I feel the answer should be :
BCP reports no errors but the data is not loaded.
because we never mentioned -Sservername while loading the data.
bcp.exe accounting..Accounttmp c:\input.txt -n -Uusername -Ppassword...
May 10, 2004 at 8:37 pm
Sorry i made a mistake, forget to save the changes after following ur instructions. Now it is working perfect. Thanx again.
April 29, 2004 at 12:56 am
Thanx a lot for your reply. I tried the way u asked to add the parameter in Execute SQL Task, but still i'm facing the same problem. Trying running the...
April 29, 2004 at 12:52 am
Thanx for the article. But when i tried to create this template, the table created in master database instead of DEMO_DB. Could u explain abt that in detail?
April 28, 2004 at 12:55 am
April 27, 2004 at 7:49 pm
The answer what mentioned is wrong, when i tried creating database with autoclose turned on, i'm able to create the database(thro' EM).
when transaction opened in model, then i can't...
April 8, 2004 at 10:17 pm
Good One. I learned new stuff. thanx a lot
March 24, 2004 at 9:24 pm