Viewing 15 posts - 106 through 120 (of 226 total)
if possible change the owner of the job to "sa" and then script. I am not sure but this might work.
Can you post your job script
March 15, 2006 at 10:42 am
if you need a break of space by table.
http://www.sqlservercentral.com/columnists/aLohia/findingtablespace.asp
You can use case statement instead of multiple queries. Please read the comments
March 15, 2006 at 9:24 am
DECLARE
@MyXML XML
DECLARE @strMyXML varchar(2000)
DECLARE
@strMyElement varchar
March 14, 2006 at 6:01 pm
Thanks Ryan
Yes I did look into the Explicit option but did not code all the way as it was getting complicated and even I cannot restrict the level to 9....
March 14, 2006 at 11:19 am
yes you are correct. I was not able to get format the XML but the output remain the same
March 14, 2006 at 9:24 am
DECLARE
@money MONEY
SET @money = 63568.2951
SELECT
ROUND(@money,2
March 10, 2006 at 4:43 pm
Do table inventory has FK constraint? if yes load the primary table and then Inventory.
Why DTS is failing ? Look into the error ?
You can consider BCP also or even...
March 10, 2006 at 4:37 pm
check or paste your event log or applicable error logs
March 10, 2006 at 4:26 pm
USe dynamic SQL for alter or create. They have to be first statement in the batch
March 10, 2006 at 4:23 pm
Good to know I am not only to be disappointed.
March 9, 2006 at 9:36 am
and if the counters is a sql variable then you refer to them as @counters (for local variable)
\
March 8, 2006 at 5:15 pm
you variable counters is null. Make sure it has a value
March 8, 2006 at 5:13 pm
DECLARE @SQLString NVARCHAR(500) is this sufficient. Try increase the size and why are you using nvarchar
March 8, 2006 at 5:11 pm
March 8, 2006 at 1:35 pm
your website is developed in what ?
ASP , ASP.NET , Java or just html
March 8, 2006 at 9:49 am
Viewing 15 posts - 106 through 120 (of 226 total)