Loner (9/19/2008)

---

Developers aren't any worse than anyone else... they just don't know what they don't know. You're well ahead of the game... you, at least, are willing to admit...

sumit kende (9/19/2008)

---

How to use sqlcmd utility with blank password. sa user having blank password. Following code gives error :=> Sqlcmd: '-P': Missing argument. Enter '-?' for help. I tried...

rajiv.gupta (9/18/2008)

---

I am using stored procedure and multiple views to show the record in Crystal reports but it is very slow. How can i fast It ?

It takes 1 min...

Heh... yeah, money will temp even the stoutest of souls. That's why I found a good SQL Server DBA job... 🙂

If you want better help, please practice the methods and recommendations found in the link in my signature below. 😉

Is there a reason you can't test it yourself and post the results?

I don't believe you need a format file when you export or import using -n with BCP or Bulk Insert.

mbookout (9/16/2008)

---

Hi!

I have a table that has a Procedures field which includes several numbers separated by a space (i.e. 99202 10060 99000 A6402). I need to count the number...

Chirag (9/18/2008)

---

another way is to right click on the proc in SSMS and select view dependencies. It will show all objects that depend on the proc and also all...

No... in fact, it wouldn't show up as anything because you simply can't...

It's important... how often will the hierarchy be made to change?

Jason,

I have to ask... what's in these files where the order they are loaded in is important?

Step 1. Throw the original query as far away as possible.

Step 2. Read the following article.

http://www.sqlservercentral.com/articles/T-SQL/63681/

Unless the hierarchy changes every minute or two, there's no sense in recalculating the same thing over and over and over...

I gotta say this first... you need to take the...

I've not written any non-TSQL in quite a bit... however, when I did, I wasn't opposed to using someone else's example to get the job done. Take a look...