Hi

It's a typical SQL injection bug. You cannot insert "Heliy's Competence Lv1" without masking the ' . Do not generate dynamic SQL statements containing values by concatenating strings. If you...

Yep, this works fine (with the restrictions you mentioned). That's why I suggested to use BCP.

Only problem, the OP wrote (s)he tries to restore a backup.

Greets

Flo

Hi

C Schaefer (11/2/2009)

---

You CAN export tables from SQL2005 to SQL2000. I just had to do that last week. May or may not give you the results...

For my curiosity, why do you need to change the DATEFIRST within your function?

Probably there is another solution.

Greets

Flo

Probably I misunderstood this part, sorry. If you are able to connect the SQL Server from another host, the firewall should be okay.

How did you try to connect to the...

Hi

Firewalls on Windows Server 2008 and Windows 7 block those requests by default. Did you customize firewall settings? See this link:

Configuring the Windows Firewall to Allow SQL Server Access

Greets

Flo

Hi Tony

You speak right out of my heart. In my opinion to write faster code is not only a question of skills but also a mindset. To write tuned code...

Hi Swapna

Could you please share your real SELECT statement and probably more information (or the code) of your procedure?

Without some more information it's quiet hard to help.

Thanks

Flo

Hi

We had (have) an equal problem.

* Ensure you installed all service packs

* Maybe decrease the maximal memory for SQL Server.

* Check for count of concurrent activities

* Check tempdb space

Check...

Hi

AFAIK there is no way to restore a 2005 backup on 2000. Script your whole database schema and execute the scrip on the destination SS2000. Use BCP to copy the...

Hi

If disk space is not a problem and you need the data for reporting, I'm always a fan of data-warehousing. Create a second database (with all fine tips of Pedro)...

Hi

Generally I agree with "SELECT *" is almost never really needed, but to write specific procedures/queries/whatever for each requirement appears to be an overkill, in my opinion. I query specific...

Hi

Since I didn't participate the previous discussions, let me share my ideas here. 😛

Disclaimer: I come from .NET side. However,if you are a Java developer, things should be quite alike.

XYZ.Data.Core...

Hi

Could you post a snippet of your java code and your procedure?

Thanks

Flo

Hi JKSQL

I have to say this. SQL Server is a (database server) service and it never should do any GUI jobs.

If you want to open some GUI applications simply use...