kapacious (10/27/2009)

---

When connecting to an oracle the db tables do not show up in the query designer however when I use a sql server db it connects fine and I...

As for Jeff using ANSI Standard code, not a bet I'd take even if he does write ANSI Standard code at times. I'm sure he uses the capabilities of either...

But we aren't talking about ANSI Standard. We are talking about MS SQL Server and most of us will use the features and capabilities of MS SQL Server even if...

I was working along today and ran into something interesting with SQL Server that I didn't know before. It's not obscure or only limited to specific environments or rarely used...

rambilla4 (10/27/2009)

---

hi psvirin,

As I mentioned, I have already enabled the remote connections for SQL...

I am running both 2005 and 2008 because Windows 7 cannot run 2000 and I can run any version including 6.5 and...

Hi Michael,

I have to agree with Microsoft because SSRS usually randomly reject normal T-SQL code and to resolve most problems it generally throws strange execution context errors which may not...

There is a project called Lucene part of the Apache project a developer created .NET version that Asp.net developers have used he moved on but others continued development so check...

Paula_sql,

There is no relevant difference between what Arun posted and what is in the link Becklery posted so you still need to find the SSRS folder in SQL...

I am sorry for the delay the answer is it depends on what your user will be doing, if your...

Nemo - 4828 (10/27/2009)

---

Hi knight..

You can try this. Go to IIS and then right click on Default Web Site in Web sites to go to its properties.

In the...

The access to SSIS you give a Windows account will be based...

Here is the MSDN page for the advanced property page.

http://msdn.microsoft.com/en-us/library/ms189357.aspx

Go to server properties and advanced to see if file stream is enabled if...

Aspet Golestanian Namagerdi (10/26/2009)

---

I know,My question is related to Managment studio environment.Now,how can I give the right of access to "Integration Service" to an windows account.Actually this will solve my...