Feeds»SQL Posts

�

tblMashedUp

SQL Blogs on MSDN

SQL Blogs on Technet

SQL Server 2008 @ Facebook

SQL YouTube Videos

SQL Posts

NNTP Server

SQL Server Service User Account

Is there a reason why an account, having administrative privileges to the
local machine, other than localsystem, should not be used to run various sql
services?
Thanks in advance

8/13/2010 5:58:03 PM

NNTP Server

SQL 2005 SSAS license

Hi. Is SSAS a part of SQL server 2005 license or we need to purchase it
separately?
Thanks,

8/13/2010 3:30:53 PM

NNTP Setup

Difficulty installing SQL Server 2005 Management Studio on Windows 7

I have SQL Server 2005 Developer's Edition and am having trouble
doing a full install on a new computer with Windows 7 Home Premium.
For one thing, I could not install SQL Server Management Studio.
I did have to bypass the script on the distribution CD. I wound
up installing
D:\ENGLISH\SQL2005\DEVELOPER\S QL Server x86\Servers\Setup.exe

8/13/2010 3:32:34 AM

NNTP Setup

MBT shoes – excellent barefoot healthy shoes

MBT shoes are a kind of excellent barefoot healthy shoes. Due to MBT
shoes are slightly weighted and spread weight evenly across the entire
foot and as your body reacts to the weight and instability of the MBT
shoes’ sole, muscles, often the neglected muscles, are forced to work
to put right this instability. MBT shoes are pursuing the vision

8/13/2010 2:08:37 AM

NNTP Server

What does red cross icon mean beside server name in SSMS in sql 20

I am using sql server 2008. I just notice there is red cross icon beside
server name in SSMS. Can anyone tell me what it means? Thanks

8/12/2010 10:30:03 PM

NNTP Server

@@VERSION Gives Different Info Than Enterprise Manager (SQL 2000)

Hello,
We have a server running SQL Server 2000 running on Windows Server 2003 R2.
When I run "select @@version" in Query Analyzer, I get the following output:
Microsoft SQL Server 2000 - 8.00.2055 (Intel X86) Dec 16 2008 19:46:53
Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT

8/12/2010 9:13:03 PM

NNTP Replication

Subscription marked inactive in SQL 2008

We are using SQL 2008 std with push transactional publishation to a SQL 2005
subscriber. The publisher and distributor are on the same server.
Out of nowhere, I received the following message.
The subscription(s) have been marked inactive and must be reinitialized.
NoSync subscriptions will need to be dropped and recreated.

8/12/2010 9:07:48 PM

NNTP Replication

Replication Issue on SQL 2005 sp3 64bit win2k r2 sp2

Looking at the log below, why would I get this error? I found that bunch of
stored procedures were invalidated at around the same time. Could this have
something to do with it?
Thanks in advance
2010-08-12 00:00:35.78 spid17s This instance of SQL Server has been
using a process ID of 1592 since 8/11/2010 8:08:22 AM (local) 8/11/2010

8/12/2010 8:18:03 PM

NNTP Server

File/Filegroup last changed

Is there any way to tell when the last time data in a file or filegroup has
changed?

8/12/2010 7:01:09 PM

NNTP Server

How to delete .txt files from \Program+Files\Microsoft+SQL+Server\MSSQL.1\MSSQL\LOG

Hi All,
We have SQL 2005 and would like to automate deletion of .txt files
from \Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG folder. We
have Maintenance plan running which creates .txt files.
Any suggestions/ideas?
Thanks IA

8/12/2010 5:06:29 PM

NNTP Setup

Named instance licensing

Hello,
I currently am doing all my licensing per proc - here's the question:
If I have a SQL Server with 2 procs, and have a 2-proc license, and I have 3
named instances on the same server, does those 2-proc SQL licenses cover all
the named instances?

8/11/2010 10:55:23 PM

NNTP Server

Stats assessment, accurate?

-In SQL2005, it is OK to have older stats provided the table has not
changed. How old is really older for optimizer or it doesn't care as
long as table table has not changed?
-Auto updates stats will update table stats only if the table data has
changed more than 20%.
-If the database auto stats update is on. It will update non-indexed

8/11/2010 8:11:46 PM

NNTP Server

Ceckpoints in SQL 2005

Does sql server maintain a view containing info on checkpoint activity? Like
when the checkpoints took place and how long they ran.
Thanks in advance

8/11/2010 6:46:03 PM

NNTP Server

What does Profiler/Perf Monitor tick marks represent?

Hi all!
I am correlating my SQL profiler trace file with Perf Monitor csv data. When
I import the performance data, I see the left side of the line graph is
numbered from 1 - 100. The graph looks great but I do not know what the 1 -
100 represents for my data. Do you know what these tick marks represent?

8/11/2010 5:56:16 PM

NNTP Server

SQL_Latin1_General_CP1_CI_AS and Latin1_General_CI_AS

Hi,
We have a large number of SQL 2000 databases having collation
SQL_Latin1_General_CP1_CI_AS. We are now upgrading to SQL2008R2.
I know that the default collation for 2008R2 British English is
Latin1_General_CI_AS. One of our clients has indicated a preference
for installing their new server with a default collation of

8/11/2010 4:34:53 PM

1 2 3 4 5 6 7 8 9 10
11 12 13 14 15 16 17 18 19 20
21 22 23 24 25 26 27 28 29 30
31 32 33 34 35 36 37 38 39 40
41 42 43 44 45 46 47 48 49 50
51 52 53 54 55

pBlogCategories

sys.books