Viewing 15 posts - 2,131 through 2,145 (of 3,221 total)
Steve the free tool from Redgate works very well, easy to use on one of my machines (XP Pro) running 2005 Express.
The other machine (XP Pro) running 2005...
February 4, 2010 at 1:20 pm
Brute force nah with finesse / elegance.
This has got me intrigued ... been a long time since working with 2000, but here may be something to stir your creative juices...
February 4, 2010 at 11:24 am
Just a wild idea, which I hope will stimulate your creative juices.
Have you considered running sp_who, at least it will tell if some one is using the database, if no...
February 3, 2010 at 2:18 pm
GilaMonster (2/3/2010)
Seriously, where are all the idi^H^H^H novice-type people coming from?
In USA they are like cockroaches - coming from under the wood work, thought the walls ... any place...
February 3, 2010 at 1:50 pm
Rowan-283474
A rather over powering number of DTS packages.
Do all packages import the data into a single table or multiple tables?
If a single table is it a...
February 3, 2010 at 1:37 pm
Tara-1044200
so far i didnt get any explanation for why space is not reclaimed when column are deleted even after shrinking.
For an explanation of what happened read these 2 articles:
Changing Table...
February 3, 2010 at 1:15 pm
This should work to convert the import to what you need
DECLARE @Sub VARCHAR(50)
SET @Sub = REPLACE((CONVERT(VARCHAR(50),GETDATE(),102)),'.','-')
SELECT @Sub
Result: 2010-02-03
February 3, 2010 at 12:44 pm
Peter Brinkhaus
I tried a new approach, where I started a nested transaction to solve the problem but since SQL Server does not support rollback of inner transactions without rolling...
February 3, 2010 at 6:36 am
Now never having had you problem but my guess would be a custom format of String.Format .
February 2, 2010 at 8:40 am
peterzeke
Have you looked at:
http://technet.microsoft.com/en-us/library/ms178710(SQL.90).aspx
Which contains:
Use the Choose Format dialog box to specify a text box format. This dialog box opens when you click the ellipsis button (...) in the...
February 2, 2010 at 7:55 am
Way back in time (1970s) the Monsanto Chemical company where by corporate head quarters employees could select their path for advancement, that is technical or managerial. Each year the...
February 2, 2010 at 7:41 am
If I were that friend of yours I would hope that you would
a) inform your friend what you've noticed unofficially (private mail, phone call)
Now this might be 'cause the company...
February 1, 2010 at 2:05 pm
milzs
MIght I suggest that you go to
http://technet.microsoft.com/en-us/default.aspx
and in the search window enter "ghost clean up"
In the list that follows you may find this of interest
There are many,...
February 1, 2010 at 11:03 am
Fishbarnriots
An area of SSMS you might consider exploring to determine if you can use a template to do what you want to do.... now I am not sure their is...
February 1, 2010 at 9:31 am
honza.mf
paul.goldstraw (2/1/2010)
--------------------------------------------------------------------------------
It seems to be happening more and more at the moment and it makes me wonder how many of the people who get the answer right in any...
February 1, 2010 at 8:40 am
Viewing 15 posts - 2,131 through 2,145 (of 3,221 total)