Viewing 15 posts - 4,606 through 4,620 (of 6,486 total)
Assuming you have some .NET expertise - you can leverage a simple WMI query to find out which services are running, or if specific services are. You could also...
February 21, 2008 at 5:09 pm
A lot of this will depend on actual usage patterns so some of these are based on past experience with clients with some similarity.
- Stay Hardware RAID, and...
February 21, 2008 at 4:27 pm
If you're looking for an auto-updating EXCEL solution - skip SSRS, and tie a data query directly into your Excel spreadsheet. You can then build your totals, and simply...
February 21, 2008 at 4:02 pm
Here's another thread. The article is a how to on how to build running totals (what you're trying to accomplish)....
http://www.sqlservercentral.com/Forums/Topic449802-203-1.aspx
February 21, 2008 at 3:49 pm
yup. 2005 logs the change to the SQL Server logs.
February 21, 2008 at 2:54 pm
In case you were looking for some info on that system SP - it's available only via OLE and ODBC connections. It's mostly documented under API cursors or OLE...
February 21, 2008 at 2:53 pm
Mh (2/21/2008)
Matt Miller (2/21/2008)
February 21, 2008 at 2:24 pm
sam (2/21/2008)
February 21, 2008 at 2:11 pm
...keep in mind that unless you plan on picking and choosing columns, you don't need to create a select statement.
In other words - if you want to just export a...
February 21, 2008 at 12:56 pm
(By the way - My name is Matt - "SSCrazy" is a "level", not a name)
First - you should read up a bit on Triggers. They're essentially the same...
February 21, 2008 at 12:50 pm
You want to make sure to take a trip through the "SQL Surface Area Configuration" tool. Look for the tab relating to "remote connections", and turn on TCP/IP....
February 21, 2008 at 12:09 pm
"How long was I dead for THIS time?" - The Unknown One, DreamScape - Torment.
February 21, 2008 at 11:19 am
I haven't seen this mentioned yet - but the SQL Server log seems to capture changes to the RECOVERY model. I just did that and I get this in...
February 21, 2008 at 11:15 am
Actually - my number one question was -
what's up with the "No More Underdog", Steve? What did Underdog do to deserve that? (well okay - that's now...
February 21, 2008 at 11:05 am
Try this on. I use the patindex to make sure I actually need to strip the first digit/character.
declare @str varchar(20)
set @str='a12345'
select @str=substring(@str,2,len(@str)) where patindex('%[0-9]%',@str)>1
February 21, 2008 at 11:03 am
Viewing 15 posts - 4,606 through 4,620 (of 6,486 total)