Viewing 15 posts - 5,941 through 5,955 (of 6,105 total)
One of the things I can tack on to this is if I'm having to run queries manually to make changes to the data, I'll start a tran. After...
January 3, 2002 at 9:06 am
It does indeed sound like a permissions issue. As if the account that the SQL Server Agent is running under can't execute whatever comprises your scripting engine...
Does the SQL...
January 3, 2002 at 8:59 am
quote:
You only need to detach the database if the log file is over 1GB in size (sql doesn't shrink logs over this...
January 3, 2002 at 7:04 am
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...
January 2, 2002 at 6:43 pm
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...
January 2, 2002 at 3:11 pm
Are the view and table in the same database or different databases? If different, same or different owners (for the databases)?
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
Edited by - bkelley on 01/02/2002 ...
January 2, 2002 at 2:11 pm
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....
January 2, 2002 at 1:46 pm
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...
January 2, 2002 at 12:48 pm
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...
January 2, 2002 at 7:18 am
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. ...
January 1, 2002 at 8:16 pm
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...
January 1, 2002 at 8:05 pm
Can you post your ADO code? Let's look at that to make sure there aren't any issues.
K. Brian Kelley
January 1, 2002 at 2:05 am
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...
December 31, 2001 at 6:42 pm
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...
December 31, 2001 at 6:33 pm
When triggers are built (or altered), you can include the following: NOT FOR REPLICATION.
As per Books Online:
quote:
NOT FOR REPLICATIONIndicates that the trigger...
December 31, 2001 at 2:29 pm
Viewing 15 posts - 5,941 through 5,955 (of 6,105 total)