Viewing 15 posts - 31 through 45 (of 81 total)
Ok.. forget I even mentioned one is on 2000 and the other on 2005.
I can have both on 2000, that's barely even an issue.
I executed instcat.sql.... no difference.
Let me get...
March 3, 2008 at 5:01 am
On my local server, yes.. but on the remote one, I wouldn't be able to check, right?
EDIT:
I found some info here:
But this seems to be a resolution for...
March 3, 2008 at 3:30 am
SELECT a.*
FROM OPENROWSET('SQLOLEDB','xxx.xxx.x.xx';'sa';'sa',
'SELECT *
FROM DService.dbo.device') AS a;
Error:
Msg 17, Level 16, State 1, Line 2
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist...
March 3, 2008 at 3:23 am
I tried using openrowset. Do I need permissions for that too?
I executed the following query on the remote server with IP of my local server in place of xxx.xxx.x.xx :
SELECT...
March 3, 2008 at 2:12 am
Should I be posting this in 'administration' now?
Please help, people!
I need to send a request to the client to grant me necessary permissions. So what exactly is it that I...
March 3, 2008 at 12:23 am
Ok I figured out what my problem was!
I mentioned only the IP Address rather than IP\instance name
and then I did the following:
LinkedServer>> Properties>> Server Options >> Use Remote Collation >>...
March 3, 2008 at 12:02 am
That would be like Device ID + Image_Surr_Key?
That's not going to work either.
Lets take an example:
Today
Device1 pushed 5...
February 27, 2008 at 10:44 pm
Thanks a ton, guys!
What I was trying to do was -
I had been given the task to compare three systems (similar working but 3 versions for 3 diff clients)...
February 21, 2008 at 5:13 am
but that doesn't show me the result in table format, chirag!
I can see it only delimited my spaces.. although I chose column aligned in query options!
February 20, 2008 at 3:08 am
Now that you have all your tables in place, why not simply 'Import Data' using the Import/Export Wizard... very convenient and has always worked for me 😎 :hehe:
February 14, 2008 at 4:31 am
That's perfect, Gail. That's exactly what I've done. Its only after I pasted the code here that I realized there was nothing in it except for update/insert into a single...
February 14, 2008 at 2:20 am
I know this does look messy but now since I've been asked to look into it,
I was wondering whether I should just leave it as it is and introduce...
February 13, 2008 at 11:44 pm
Ok this is the exact scenario:
I have a staging table for Ads. It stores Ad_ID, Description, etc.
We have an SP that imports these Ads from the staging table into our...
February 13, 2008 at 10:03 pm
With DB set to compatibility level 90, which uid_design am I ordering by here..... because this works:
SELECT DISTINCT uid_design AS U1, uid_design AS U2
FROM Ad_Master_Import
ORDER BY uid_design
February 11, 2008 at 5:55 am
Gail, do you mean the syntax is incorrect in SS 2k5?
February 11, 2008 at 3:49 am
Viewing 15 posts - 31 through 45 (of 81 total)