Viewing 15 posts - 3,241 through 3,255 (of 5,393 total)
Stefan Krzywicki (4/18/2011)So how is it for scheduling automatic jobs? The built-in zip is very limited, that's why we got the full version.
You can use Windows Scheduler and the command...
-- Gianluca Sartori
April 18, 2011 at 7:45 am
If somebody asked me for a compression tool, I would recommend IZArc, which is free and handles a lot of archive types, including RAR and ZIP.
http://www.izarc.org/index.html
-- Gianluca Sartori
April 18, 2011 at 7:27 am
Did I hear two cents? Back to my regular avatar!
It has been nice to be a lizard for some days. 🙂
-- Gianluca Sartori
April 15, 2011 at 6:19 am
If you just have to run the queries, you can use SSMS. You can execute queries against a group of registered servers, by right clicking the group and selecting "new...
-- Gianluca Sartori
April 15, 2011 at 6:04 am
Grant Fritchey (4/14/2011)
-- Gianluca Sartori
April 14, 2011 at 6:17 am
santosh Sai (4/13/2011)
Thanks.But normally I am taking backup of Sql data through NT Backup in every half an hour. NT Backup supports any Microsoft product to take backup.
I'm not...
-- Gianluca Sartori
April 14, 2011 at 6:09 am
I'm afraid you will have to set up a different thing.
Mirroring could be one. It depends on what you want to achieve, the downtime you can afford, the windows AND...
-- Gianluca Sartori
April 13, 2011 at 9:10 am
santosh Sai (4/13/2011)
Hi Gianluca Sartori,But the Premium Edition of SBS includes the features of Microsoft SQL Server 2000. Then why it does not support SQL Clustering.
In order to set up...
-- Gianluca Sartori
April 13, 2011 at 3:02 am
ALZDBA (4/13/2011)
I'm infected too 😀
You were already, and you didn't know: How Is a Lizard Like a Motorcycle 😀
-- Gianluca Sartori
April 13, 2011 at 1:54 am
You need Windows Server Enterprise Edition to build a cluster, it can't be done with SBS.
-- Gianluca Sartori
April 13, 2011 at 1:47 am
LutzM (4/12/2011)How about a Friday poll: "Do we want GilaMonster back?"
Here we go:
http://www.sqlservercentral.com/Forums/FindPost1092608.aspx
-- Gianluca Sartori
April 13, 2011 at 1:40 am
ALZDBA (4/13/2011)
Roy Ernest (4/12/2011)
You all are making me looking foolish because I am laughing when going through a SQL Forum. I am getting some strange looks. 😀ditto :w00t:
+1
[font="Comic Sans MS"]Viva...
-- Gianluca Sartori
April 13, 2011 at 1:30 am
Roy Ernest (4/11/2011)
Craig Farrell (4/11/2011)
GilaMonster (4/11/2011)
Ok, had enough complaints about the lizard. Let's see if this is better.
:blink: Whaaa?
Good to see the dead hopeless romantic virgin isn't forgotten. I...
-- Gianluca Sartori
April 11, 2011 at 2:56 pm
Steve Jones - SSC Editor (4/11/2011)
Happy Monday. :hehe:
Almost finished for me.
Happy Monday everybody!
-- Gianluca Sartori
April 11, 2011 at 9:34 am
This should do the trick:
DECLARE @code_positions nvarchar(max)
DECLARE @column_names nvarchar(max)
DECLARE @sql nvarchar(max)
SET @code_positions =
STUFF
...
-- Gianluca Sartori
April 11, 2011 at 8:51 am
Viewing 15 posts - 3,241 through 3,255 (of 5,393 total)