Done right they are very useful. I have used them in the past and don't remember have the issues you indicated.

All I can say is test it in a...

dhananjay.nagarkar (4/13/2013)

---

Hi Friends,

I have reporting TSQL query- in this query within the select statement I have 2 fields 1) Age (working Days) and 2) Age Group(Working days).

the requirement demands that...

One, are you using full text indexing, and two it would help if you also provided the full and complete error message you are getting.

mjarosz (4/13/2013)

---

Hello,

I have question regarding backup SQL'05.

Please look ta my script :

sqlcmd -S srv_name -U sa -P pass -Q "BACKUP DATABASE Database_name TO DISK = 'D:\Backup\%date%_Database_name.bak' WITH NAME = 'Database_name_backup',...

Do you mean like to have a warning type message box pop up to be sure that the action you are about to do is what you really want to...

Look down to attachments while writing a post.

I have to agree with Steve on this one.

dkschill (4/12/2013)

---

So I am exploring PowerShell, and found a DB with .Databases that I can't see in sys.databases.

I ran this following (starting from the Machine level with sqlps):

$i...

Doesn't answer my question completely, but if it is a user DNS, does the user running the...

TravisDBA (4/12/2013)

---

Major,

I understand exactly what your saying, but I cant address that particular aspect properly because I don't work with the end user directly. My laisons are more with the...

Can you try uploading your procedure in a text file (*.txt)? I had issues like this at a previous employer and that was the only way to provide code...

I'd start here: Data source name not found and no default driver specified.

Tell us about the DSN you are using, is it a System, User, or File DSN?

Melanie Peterson (4/12/2013)

---

I tried to post the entire stored proc, but something in it was causing a problem with the forum. I suspect it's either the table creation or dropping...

Please post the stored procedure and how you are invoking it as well.

How are the two tables related?