Viewing 15 posts - 4,696 through 4,710 (of 9,722 total)
kiran.rajenimbalkar (2/22/2012)
The first two Active records having two dofferent dates i.e.
org_club_status org_rec_eff_dt org_status_change_dt
Active 1988-07-01 1988-07-01
Active ...
February 22, 2012 at 9:31 am
Anything you write and run in SSMS is T-SQL. You can implement CLR to access .Net and C#, but that reaches out of SQL Server to grab the assemblies and...
February 22, 2012 at 9:02 am
GSquared (2/22/2012)
GilaMonster (2/22/2012)
He's actually put me and my co-leads in a rather nasty position by contacting potential sponsors...
February 22, 2012 at 8:20 am
GilaMonster (2/22/2012)
WayneS (2/22/2012)
Really? I'd always heard that cancelling it would save what it has already done, which is why I was considering that method. Okay, scratch that idea.
That's reorganise. Rebuild...
February 22, 2012 at 8:17 am
It depends on so many factors, including where the burden of the processing is occurring.
Grab an execution plan both from the local server and the remote box and compare...
February 22, 2012 at 8:15 am
Is the Poll added by mistake?
What code are you using for the .csv and what code are you using for the Excel spreadsheet?
What you posted isn't too clear because...
February 22, 2012 at 8:11 am
Kiran,
Thank you for providing DDL code, INSERT statements, and a expected result, but I don't know your data well enough to understand what you mean by "modify".
Please be more clear...
February 22, 2012 at 8:07 am
This question needs more clarification.
How are the parameters being populated?
What about the report? Is it an auto-run or is it printed upon request?
I'm not sure about the rest...
February 22, 2012 at 8:04 am
Please post DDL code, a sample data INSERT statement, and what code you're already using to achieve your current solution. That will help us test any advice we give you.
Also,...
February 22, 2012 at 8:02 am
You may have a bad install file, but on the off chance that you don't, check the following:
Available disk space (is it enough for the setup files?)
Attributes of the cab...
February 22, 2012 at 7:58 am
Well, okay. There's still a non-Replication method around this.
Depending on your edition, you could use Log Shipping or Data Mirroring to get a readable version of a secondary server. Log...
February 22, 2012 at 7:44 am
GilaMonster (2/22/2012)
Would you have been irritated if your regional mentor or an organiser of another SQL Sat in the same area had...
February 22, 2012 at 7:41 am
In addition to the previous comments, I also advise running PerfMon on the 2005 server to see if the hardware is at capacity or not.
If you're starting to see...
February 22, 2012 at 7:37 am
I've never used third party tools for replication.
Question, though. This secondary server requirement for always online... Is it because you're using it as a report server?
February 22, 2012 at 7:32 am
Viewing 15 posts - 4,696 through 4,710 (of 9,722 total)