Viewing 15 posts - 31 through 45 (of 101 total)
[p]I learnt new thing today. Thanks Ronmoses.[/p]
KSB
-----------------------------
Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha
July 11, 2010 at 11:54 pm
You basically have to rewrite it. Scripts are one of the things that the upgrade wizard doesn't really do anything with.
[p]I accept. And you can use Script Task instead...
KSB
-----------------------------
Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha
July 9, 2010 at 12:27 am
[p]May this link is useful for you: Table Variable :Doesn't care[/url][/p]
KSB
-----------------------------
Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha
July 9, 2010 at 12:12 am
You essentially need to re-install SQL Server to change the server collation. You will need to backup all databases that need to be retained.
That's true.
KSB
-----------------------------
Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha
July 9, 2010 at 12:04 am
[p]In BIDS, right click on your package -> click on View Code -> and search for your configuration file name or configuration name. Modify file name there if anything is...
KSB
-----------------------------
Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha
July 8, 2010 at 11:45 pm
[p]I have attached a screen shot of Target Connection manager. Kindly check that let me know if any other information is required. [/p]
KSB
-----------------------------
Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha
July 8, 2010 at 11:36 pm
[p]How diffpckcfg.dtsconfig file been created? Did you create this configuration file along with pckcfg.dtsconfig? May be it is helpful when you view code of your package.[/p]
KSB
-----------------------------
Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha
July 8, 2010 at 7:47 am
[p]Good point, covered nicely. I like it.:smooooth:[/p]
KSB
-----------------------------
Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha
July 6, 2010 at 11:55 pm
As I mentioned above, that's almost certainly because your master database is in compatibility level 80 (SQL 2000), while your other databases are in compatibility level 90 or 100 (SQL...
KSB
-----------------------------
Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha
July 5, 2010 at 11:41 pm
[p]This query returns count as 20 when executing against "master" DB (excluding '\' ASCII character number 92) and returns 21 when executing with other databases.[/p]
KSB
-----------------------------
Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha
July 5, 2010 at 7:53 am
[p]Thanks yaar.. good question..
To disable..
[/p]
DISABLE TRIGGER Person.uAddress ON Person.Address;
GO
[p]And to Enable triggers, we can use this query.. [/p]
ENABLE Trigger Person.uAddress ON Person.Address;
GO
KSB
-----------------------------
Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha
July 2, 2010 at 12:07 am
[p]It is very difficult to understand... and not able to get logic behind this query.. :alien:[/p]
KSB
-----------------------------
Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha
July 1, 2010 at 11:58 pm
[p]Hhhhh.. finally got it.
Thank you Mr. Elliott for your suggestion, it worked.
solution for this problem is: D:\temp\[/p]
KSB
-----------------------------
Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha
June 30, 2010 at 4:22 am
[p]Yes.. it is tricky, this query also results the same..[/p]PRINT LEN(@StringArray) + '-' + LEN(@Delimiter)
KSB
-----------------------------
Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha
June 30, 2010 at 12:13 am
[p]Good question.. Also the tempdb system database is a global resource that is available to all users connected to the instance of SQL Server[/p]
KSB
-----------------------------
Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha
June 28, 2010 at 11:36 pm
Viewing 15 posts - 31 through 45 (of 101 total)