Forum Replies Created
Viewing 15 posts - 181 through 195 (of 497 total)
-
RE: load a file into multiple databases table
ihpk74 (5/20/2014)
....... load the data from a file into multiple databases table. thanks in advance..If you really mean that then you'll need to look at the multicast transformation.
Regards
Lempster
-
RE: SQL Profiler - Server side Trace
Gail beat me to it. 🙂 What you describe is not possible. You could have a trace restart after a SQL Server restart if it is initiated by a stored...
-
RE: high CXPACKET and LATCH_EX
smtzac (5/12/2014)
Hi Mr. Gila,I have same first 3 issues. Can you please give suggestions?
I just spent a long time replying to this and then an error occurred when I submitted...
-
RE: SSMS (manually) generated jobs run long, then fail.
You mentioned that you use Maintenance Plans. One of the reasons that I don't is that I've experienced issues where a task in a Maintenance Plan fails because a database...
-
RE: Create Table Excel Destination in SSIS
You're welcome. 🙂
-
RE: Create Table Excel Destination in SSIS
So are you creating your Excel destination dynamically? If so, then this snippet from an Execute SQL Task I've used to do the same thing may help:
CASE WHEN c.DATA_TYPE IN('nvarchar','ntext','text','varchar','varchar','char','nchar','xml','uniqueidentifier')... -
RE: Datatypes In Your Mind
Koen Verbeeck (5/5/2014)
Misread the question and thought the data type was supposed to store negatives as well...Need more caffeine.
+ 1 to that. Apostrophes can be important eh?!
-
RE: Stairway to Database Source Control Level 1: Setting Up For Database Source Control
Jack Corbett (4/24/2014)
Good opening article and I look forward to the rest of the stairway. I'm in the process of trying to get my current workplace to... -
RE: How to search for replication information messages e.g "The initial snapshot for publication is not yet available."
:ermm: I was responding to a particular statement in your original question:
DennisPost (4/23/2014)
Unfortunately, replication monitor doesn't give you any indication that a subscription is waiting for a snapshot.I don't have...
-
RE: How to search for replication information messages e.g "The initial snapshot for publication is not yet available."
Replication Monitor does give you that information, but you have to drill-down on the individual tabs. The 'Distributor to Subscriber tab is where you want to look.
Regards
Lempster
-
RE: Any possibilities to save the message tab information in SSIS
Phil Parkin (4/23/2014)
I don't know a way of doing this directly. Maybe you can load the query from the file into a string variable, append SELECT @@ROWCOUNT, then execute that?Yes,...
-
RE: Any possibilities to save the message tab information in SSIS
So basically you want a row count?
In that case, add a 'SELECT @@ROWCOUNT' statement to your Execute SQL task in SSIS, set the ResultSet to 'Single Row' and then on...
-
RE: Deployment Failure Heirarchy
cook155 (4/21/2014)
Jeff, Would that mean i made an extra attribute and need to delete it? How do i do that?You don't need to delete any data. The 'duplicate' you are...
-
RE: how to rollback restoration
No. If you've overwritten a database without backing it up first then that database is lost. I assume you are not using source control and you didn't save a copy...
-
RE: High Memory is 70% & growing Fast
As you seem unwilling to believe that what you are seeing is normal behavior for SQL Server, I can only reiterate my original somewhat flippant suggestion that you add more...
Viewing 15 posts - 181 through 195 (of 497 total)