Viewing 15 posts - 5,401 through 5,415 (of 7,168 total)
Jeff Moden (7/21/2011)
...BWAA-HAAA!!!! What's wrong with DOS??? 😛
...
Heh...I'll assume that was a rhetorical question 😛
July 21, 2011 at 9:16 pm
Welcome!
dgossdba (7/20/2011)
1. Will the command just terminate and all statistics that were updated remain that way, and any statistics that were not touched utilize original statistics?
Yes.
2. Will the...
July 21, 2011 at 4:32 pm
Nothing immediately comes to mind. It would be interesting to know the root cause. How much time do you have to fiddle with this to find the root cause? Time...
July 21, 2011 at 4:05 pm
WebTechie38 (7/21/2011)
I had to put quotes at the beginning and the end of the expression.
After that, it evaluated properly.
Now the last part:
1. Load the...
July 21, 2011 at 12:29 pm
abdielmomo (7/21/2011)
In fact, I want to copy files from one folder to another when a new row is inserted in a table.
If you are saying that you want the file...
July 21, 2011 at 12:03 pm
WebTechie38 (7/21/2011)
Here is the expression that I am using:
Data Source=@[User::CurrServer]; User ID=RptUser;Initial Catalog=MY_CUSTOM;Provider=SQLNCLI10.1;Persist Security Info=True;Auto Translate=False;Application Name=SSIS-Package-{44F8A456-FBBD-4165-8B66-A1E1A1D38E75}MYSERVER.MYDOMAIN.NET.MYDATABASE;
Here is the expression error message:
TITLE: Expression Builder
------------------------------
Expression cannot be evaluated.
For...
July 21, 2011 at 11:24 am
July 21, 2011 at 10:08 am
😛
Yeah, if you can start storing 1 instead of NULL, so that when you want to use the column you don't have to convert NULL to 1 on the fly,...
July 21, 2011 at 9:40 am
Excellent! HTH
PS Read that article about variable names 😉
July 21, 2011 at 9:35 am
Ninja's_RGR'us (7/21/2011)
TheSQLGuru (7/21/2011)
July 21, 2011 at 9:27 am
I won't say much more about the actual script itself. I think you are close, and I gave you a solution in C# that all you have to do is...
July 21, 2011 at 9:22 am
It sounds like you're close. Please post the expression you're trying to use as well as the exact error message you get when it fails to evaluate.
If you don't mind...
July 21, 2011 at 9:09 am
Jannie-186227 (7/20/2011)
HiAfaik I know the MGMT studio is sluggish on x64 as it's 32 bit.
This might have the same issue for your machine.
That's a good lead. I am curious about...
July 21, 2011 at 9:06 am
I would:
1. Create an Active Directory group that corresponded to each database instance, e.g. PayrollSqlSysAdmins.
2. Add the relevant AD User Accounts into the AD Groups.
3. Add each AD Group to...
July 20, 2011 at 4:13 pm
Thanks for the reply Steve.
S. Kusen (7/20/2011)
It seems like the OP wants the replication to continue, but doesn't require the one specific article any longer to be replicated.
Correct.
Therefore, they want...
July 20, 2011 at 9:36 am
Viewing 15 posts - 5,401 through 5,415 (of 7,168 total)