quote:

---

You only need to detach the database if the log file is over 1GB in size (sql doesn't shrink logs over this...

With the talk that Yukon will allow queries and stored procedures in languages other than T-SQL (it supports the .NET Framework), I think the role of the DBA is going...

I created a table tableInsert and a view viewInsert to test if there was a difference. Opening the view and inserting, I saw the following in Profiler:

exec sp_executesql N'INSERT...

Are the view and table in the same database or different databases? If different, same or different owners (for the databases)?

K. Brian Kelley

bk@warpdrivedesign.org

http://www.sqlservercentral.com/columnists/bkelley/

Edited by - bkelley...

If you are going to use Dynamic SQL queries, either through EXEC[UTE] or xp_executesql, you're going to have to give permissions to the tables. There's no workaround for this....

Unless I'm mistaken, the script given uses RPC only. There isn't anything there for FTP. I think you're just happening to hit a share on the NT 4...

Nigel's right... it's usually the DBA that starts asking the hard questions.

Case in point, an application development team wanted a quad-processor for their SQL Server back-end. Because of the...

We just went through this cycle again.

Basically we chose experience and programming over the MCDBA. Had a candidate with the MCDBA, decent experience. No real programming background. ...

Doesn't void the warranty... but they won't come look until you've got HP memory in there. Which basically means you've got to have some on hand.

Though with...

Can you post your ADO code? Let's look at that to make sure there aren't any issues.

K. Brian Kelley

bk@warpdrivedesign.org

http://www.sqlservercentral.com/columnists/bkelley/

Is the SQL Server setup to use NT authentication only or is it setup for mixed mode? If it's setup for NT authentication mode, you can't login with a...

I tried using a leading or ending space and that didn't produce results that were any different. Since you're doing string manipulation, you may try and convert it into a...

When triggers are built (or altered), you can include the following: NOT FOR REPLICATION.

As per Books Online:

quote:

---

NOT FOR REPLICATION

Indicates that the trigger...

I agree with Steve on this one. A good example is Cisco's certification program. CCNA commands a little respect (more so than the MCSE garners nowadays). Someone...

I do believe Profiler is reporting back not just the retrieval time from the engine's perspective, but total time to include delivery to the client. We've seen changes in...