Viewing 15 posts - 4,411 through 4,425 (of 7,496 total)
halifaxdal (10/17/2008)
Actually it is working !
You did not use a where clause, so all your rows should have the value "TechOwner_Department" for column Test !
But all the records have been...
October 17, 2008 at 1:13 pm
- it is a client setting. But that setting is used for any object at create time, so the object will use that setting.
- Script the ddl for your tables...
October 17, 2008 at 1:09 pm
halifaxdal (10/17/2008)
I did the following in Access:
I export the table to mdb, I tried...
October 17, 2008 at 1:03 pm
- which schema do you expect your object eventstatus_bek_IGA to belong to ?
- do you have the needed grants to be able to insert into that object ?
October 17, 2008 at 12:52 pm
- What's your ANSI padding set to ?
- use datalength in stead of LEN !
October 17, 2008 at 12:49 pm
You need to configure the security settings for MSDTC at the server to accept the type of connections you want.
This gui is different, depending on the service pack of the...
October 17, 2008 at 12:39 am
jaggity (10/16/2008)
Thanks ALZDBA, but how would I associate the recordset with a parm name?
You don't.
If you want to pass a rowset, just perform a select statement in your poc as...
October 17, 2008 at 12:06 am
A proc's return value is to be used more like an execution return code (ok or not ok)
However you can return a row set !
Just run the select statement within...
October 16, 2008 at 12:39 pm
how about the MSDTC settings server side ?
Is MSDTC running ?
Is it configured to accept your time of server-server connection ?
October 16, 2008 at 12:30 pm
I'm sorry. I noticed I pointed you to my service broker article and scripts.
Must have been a twist of mind :crazy:
The mirror testing I was on Two clients with dev-edtn...
October 16, 2008 at 11:53 am
I doubt if this is something one should doing "in transaction scope" like within a sproc.
I would convert the sproc into a single sqlagent job, containing of multiple steps.
If you...
October 14, 2008 at 10:49 am
Alren (10/13/2008)[hr..Now say user A is a database administrator
G1 the DBA group (sysadmin rights)
G2 a user group able to select some records (in normal situation)
--> this is why I'm afraid...
October 14, 2008 at 12:09 am
IMO DENY is the way to go !
It will prevent users of the windows group from accessing your db.
Maybe users are member of more then one group, so they may...
October 13, 2008 at 12:28 pm
- Check the installation log files for the reasons why it did no install on the second node !
Only then you can fix it.
October 13, 2008 at 12:23 pm
-you need to enable tcpip protocol using Sql server configuration manager.
(sql2005 network configuration for you rinstance)
-your client box needs to configure its firewall to be able the connect using...
October 11, 2008 at 4:50 am
Viewing 15 posts - 4,411 through 4,425 (of 7,496 total)