You can use the xp_logininfo procedure to returns information about Windows users and Windows...

You mentioned that you've been using Text Search engine in the past, so this advice assumes that at least some of your routinely searched terms are contained in text columns....

shahgols (4/16/2012)

---

Thank you very much for that information!

I have already created that user using code, and it still cannot log in...that's what I see in SQL Server logs. It's...

I hate working with Excel as a datasource. Business users love it, because it's easy to enter data and the design is flexible. However it's problematic when used in an...

Daryl Lloyd (4/16/2012)

---

...

b) use a view to union all the tables together and query that instead [drawbacks - our tables are stored in separate database instances and cannot be indexed,...

A primary key column can't contain NULL. It would be like a street with no name or a product...

TravisDBA (4/17/2012)

---

Hmmmm. I look at the 2007 Top 100 list on that site and I noticed that Microsoft (correct me if I'm wrong) is not on that list. No big...

Select permission on some extended stored procecures and system tables is required for basic connectivity, especially when users are connecting via the ODBC driver. Whatever permissions that SQL Server 2005+...

Companies tend to lavish more attention and rewards on whatever department is integral to their core business model. For example, you can have a showroom floor full of fat and...

I have a question for someone here who has experience with MySQL. I've heard that with MySQL, there are are options for multiple table storage types, one of which is...

Pete.murray (4/2/2012)

---

Thanks for the reply guys,

GilaMonster - I think you gave me the perfect direction to investigate in, I can see all the information I need to identify the...

Before killing the process that had been running for 7 hours, did you check see if it was was in a blocked state, what was blocking it, and wether it...

In the past most data orginated in a database because it was deemed important enough by users that they entered it manually (patient charts, student records, inventory, etc.).

Today, the...

Henrico Bekker (4/12/2012)

---

I've done it as well... "how do you detach a Log Shipped tempdb that is in Read...

Who wouldn't want six weeks of vacation, the option to work remotely from home every day, a personal assistant, and a $120,000 salary?

However, if applicants were to write a description...