Viewing 15 posts - 4,891 through 4,905 (of 14,953 total)
You could write one, using various system views, a couple of cursors, and some light-weight dynamic SQL.
However, I have to question "deleting all user-defined users" in the database. That'll...
February 21, 2011 at 12:03 pm
MaricopaJoe (2/21/2011)
Case in point. ...
February 21, 2011 at 12:01 pm
You could definitely set up a linked server for that.
I use OpenRowset for that kind of thing, instead. A definition file, that maps out the columns based on the...
February 21, 2011 at 11:58 am
That's one of the things replication was designed for, so staying off of that does limit your options. Personally, I use snapshot replication for that pretty routinely.
One solution I...
February 21, 2011 at 11:38 am
I guess it depends on the type and structure of text in the file.
I generally use OpenRowset for querying text into SQL Server. It's pretty straightforward on structured data...
February 21, 2011 at 9:56 am
I've been reading up on it, and downloaded the CTP to my home computer. (For most small businesses, my desktop computer at home would be a decent server farm.)
There...
February 21, 2011 at 9:00 am
You could use SSIS, but XQuery will be more efficient.
As well as the link Lutz gave you, MSDN and BOL have a whole section on using XML in SQL Server....
February 21, 2011 at 8:49 am
I just tried a self-referent query on my 2005 and 2008 servers, and it worked in both cases.
On the 2008 box, select @@servername and see if it matches what you...
February 21, 2011 at 8:47 am
Take a look at your linked servers (sys.servers) on both machines. It looks like the 2005 box has itself set up as a linked server.
February 21, 2011 at 8:41 am
Are you familiar with the DateDiff function? It will calculate the number of hours between dates, with a few caveats.
Take a look at it in Books Online or on...
February 21, 2011 at 8:40 am
The most common uses are backup management, and index management.
The maintenance plan backups are okay, but they lack a few bits of flexibility, with regards to doing things like test-restores...
February 21, 2011 at 8:37 am
Can you insert those results in a temp table and then query that?
February 21, 2011 at 8:33 am
Or define a user-defined-data-type that'll hold the date range you're looking for.
Dates in SQL Server are stored as numbers. You could easily extend to bigint for the date part,...
February 21, 2011 at 8:26 am
Grant Fritchey (2/21/2011)
And this post makes 10,000 points. On to getting 10,000 posts.Figured I'd break the threshold on The Thread.
Grats!
(For some reason, I keep thinking you were ahead of me...
February 21, 2011 at 8:17 am
Stefan Krzywicki (2/18/2011)
Brandie Tarvin (2/18/2011)
Answered. @=)Probably not the answer you want to hear, though, Stefan.
It doesn't matter what answer I want to hear as long as it works. Of course,...
February 18, 2011 at 12:36 pm
Viewing 15 posts - 4,891 through 4,905 (of 14,953 total)