Viewing 15 posts - 7,081 through 7,095 (of 7,164 total)
This should work fine...it may just be a situation where the change has not propagated to all domain controllers, specifically one being actively used by your SQL Server instance for...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
February 28, 2011 at 2:06 pm
Setting up a server-side trace is the first thing that comes to mind. Trace will allow you to capture the activities for a specific set of logins at a very...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
February 28, 2011 at 1:26 pm
PS check out the -b option of sqlcmd...it may be useful in this context if you are not handling errors within your script and do want sqlcmd to set the...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
February 28, 2011 at 12:54 pm
ALZDBA,
I could see using xp_cmdshell to avoid pushing a 1GB file across the wire. I do agree with you however that sqlcmd would be preferable over osql.
mailtosaravanan.m,
xp_cmdshell may not...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
February 28, 2011 at 12:49 pm
Here is an interesting post regarding the use of ExDAV from ASP.NET:
http://blogs.technet.com/b/kclemson/archive/2004/01/23/62247.aspx?PageIndex=2
There is no code sample for reading contacts but it might be worth a look.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
February 26, 2011 at 4:42 pm
Whatever or whoever is kicking off your SSIS package will be forced to authenticate to that network location.
Can you tell us more about the execution context? Is it a...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
February 25, 2011 at 1:55 pm
I agree with that is is an "odd" choice. Setting up and maintaining replication in one environment may not be too bad...but throw in the portability issue and you multiply...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
February 25, 2011 at 1:38 pm
File extensions exist to let the viewer of the file name as well as to tip off the operating system as to what the program to use to open the...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
February 25, 2011 at 12:44 pm
Sorry for the hasty reply initially...
Some options are to run SQL Server Express Edition on your Exchange server so you can use ExOLEDB locally. This could let you bridge to/from...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
February 25, 2011 at 12:10 pm
Lookup Linked Servers for your version of Exchange. There is a provider for 2003.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
February 25, 2011 at 11:46 am
That's pretty cool Wayne...that's why I wanted "in" on this post. Running an estimated execution plan with the sub-query method using MAX()/OVER PARTITION BY and the CTE (common table expression)...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
February 25, 2011 at 11:23 am
GSquared already mentioned it in a previous post:
GSquared (2/24/2011)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
February 25, 2011 at 11:13 am
SQLkiwi (2/24/2011)
e90fleet (2/24/2011)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
February 25, 2011 at 10:05 am
I would like to take a shot at this one...can you please provide the DDL for your tables and some DML to build some test data?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
February 25, 2011 at 8:51 am
Double post...please direct all replies here:
http://www.sqlservercentral.com/Forums/Topic1069402-392-1.aspx
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
February 25, 2011 at 8:06 am
Viewing 15 posts - 7,081 through 7,095 (of 7,164 total)