Viewing 15 posts - 2,146 through 2,160 (of 7,168 total)
Without more detailed information about what you are trying to do and what you have tried so far all I can do is refer you to Books Online:
February 5, 2013 at 5:55 am
Just a heads up, I just noticed you're using DBNETLIB which is a deprecated driver in SQL 2008 and to my knowledge is no longer supported being supported in SQL...
February 5, 2013 at 5:48 am
It's possible SQLdm is getting it's information from DMVs (if that counter is even available through the DMVs) which are not guaranteed to be exactly the same reading as what...
February 5, 2013 at 5:41 am
T-SQL supports all your common comparison operators, e.g.
=
<
>
!= or <>
Comparisons involving two rows might imply the comparison would take place in a WHERE-clause. If you provide table definitions...
February 5, 2013 at 5:40 am
ngreene (2/4/2013)
What is stupid is I am running Interop 2010 on a Server 2008 box and this change still fixed my problem. What the heck!
The issue is that Office...
February 5, 2013 at 5:36 am
shreyanshbhatt (2/5/2013)
Is it something to do...
February 5, 2013 at 5:18 am
When you say "run using the same account" do you mean the jobs have the same owner?
Are there any job steps that use proxies?
February 4, 2013 at 1:10 pm
opc.three (2/1/2013)
February 4, 2013 at 6:33 am
Remote DAC connections are disabled by default so no worries there, just leave them disabled if you're concerned.
SELECT *
FROM sys.configurations
WHERE name = 'remote...
February 3, 2013 at 9:52 pm
Filtered means no response was received. Just to confirm, did you run the command on mainpc or from a different machine, i.e. the remote client? Make sure there are no...
February 3, 2013 at 9:49 pm
iamsql1 (2/1/2013)
can i use sql command for it?
No, Table name or view name variable.
February 1, 2013 at 3:09 pm
You can decide that in the Expression of the Variable that determines which table name your OLE DB Destination points to.
February 1, 2013 at 12:43 pm
ratheesh4sql (2/1/2013)
Any one help me how can to Change default SQL port from 1433/1434 to 9877/9878, if i change is that portt will be changing in Cluster listener in Always...
February 1, 2013 at 9:48 am
If the error number is 13,000 or greater and the severity is 18 or lower then it could have been either the database engine or a user. Users cannot explicitly...
February 1, 2013 at 9:26 am
There are a lot of rules around creating an updatable partitioned view.
Modifying Data in Partitioned Views
You can always fall back on implementing an INSTEAD OF TRIGGER.
February 1, 2013 at 7:18 am
Viewing 15 posts - 2,146 through 2,160 (of 7,168 total)