Viewing 15 posts - 5,176 through 5,190 (of 6,105 total)
Microsoft has been very good about the stability of their last two SQL Server service pack betas. Both SQL Server 2000 SP2 Beta and SQL Server 7 SP4 Beta were...
August 12, 2002 at 8:55 am
Do the maintenance jobs run about the same time as you are seeing the drop in buffer cache?
K. Brian Kelley
August 12, 2002 at 8:42 am
Are the web users not able to execute the stored procedures currectly? What's not working?
K. Brian Kelley
August 10, 2002 at 2:40 pm
There are also some articles around the web with regards to integrating VSS more tightly with SQL server... rather than using it just as a repository of scripted databases. We've...
August 9, 2002 at 9:38 pm
If you're using SourceSafe, one thing you can script the whole database. As long as you use the same scripting options each time, you have two scripts which are comparable...
August 9, 2002 at 7:06 pm
As long as the login used (SQL Server or NT) has sysadmin rights, you should be fine. We use NT logins all the time.
K. Brian Kelley
August 9, 2002 at 7:01 pm
Starting from the top: Can you send and receive email from Outlook with the profile?
K. Brian Kelley
August 9, 2002 at 9:25 am
I may monitor it long term, but I don't have an alert set up on it. At the times the alert fires, what else is going on? Is there a...
August 9, 2002 at 9:22 am
Typically, we don't consider the order of columns important in RDBMSes, as we can always specify order in our queries. If it is important in your case, however, there's no...
August 9, 2002 at 9:19 am
Is SQL Server the only memory-intensive application on the system?
K. Brian Kelley
August 9, 2002 at 6:51 am
August 8, 2002 at 2:08 pm
There's a system function which does the conversion in SQL2K. Take a look at dbo.fn_varbintohextstr and see if it fits your needs.
K. Brian Kelley
August 8, 2002 at 10:45 am
I agree that when the author is available to respond to questions, that's always great. I think I had a question on DTS and was able to send to Brian...
August 8, 2002 at 9:35 am
Have you tried running DBCC SHRINKFILE with first the NOTRUNCATE option to move all the data to the front of the file followed by running it again with TRUNCATEONLY to...
August 8, 2002 at 7:27 am
I remember having problems converting varbinary strings myself (a Citrix Metaframe XP datastore has a few columns which are binary) but eventually plugged through with the help of a function....
August 7, 2002 at 6:29 pm
Viewing 15 posts - 5,176 through 5,190 (of 6,105 total)