RE: SQL Server Service Pack 3
I had this problem and I fixed it by making the user account that runs the SQL service a member of the administrator group. I was trying to run the service with less than full rights on a test box.
2003-06-04
insert
RE: SQL Server Mag User Study
Hi Crispin, quote: Just completed it. Not sure what I got myself into. Maybe now I will be getting emails asking if I am lonely... Short survery and useless if you ask me. I already receive those mails asking if I wanna be friend to ???. Short surveys I like best. I only did this […]
2003-06-04
1 reads
RE: copy DTS jobs between servers
Here is an easier procedure I found in technet: Step 5: How to Move DTS Packages Step 5 is optional. If DTS packages are stored on the source server in the SQL Server or the repository, you can move them if you want. To move DTS packages between servers: Save the DTS package on the […]
2003-06-03
1 reads
RE: sql agent - job manager stuck..
Steve, It is sql server 2000 standard edition, service pack 2. I feel like this started when we changed our email to microsoft exchange server but i can't say for sure. I checked my server logs and event viewew on the NT 4.0 server box and no messages. I guess I can reboot the box […]
2003-06-03
1 reads
RE: Cursor the only option ?
Here is a way to do it without a cursor, although maybe this is not much better. -- create tables CREATE TABLE qualifications(ClientID int, Qualifications varchar(20)) Create table Client (ClientID int,ClientName varchar(20)) -- populate the tablea insert into qualifications values(1,'BSc') insert into qualifications values(3,'BA') insert into qualifications values(1,'MSc') insert into client values(1,'John Smith') insert into […]
2003-05-29
RE: Checking if An object Exists
That is kinda backwards. I always use IF COALESCE(objectproperty(object_id('TEST_TABLE'),'IsTable'),0) = 1 begin drop table TEST_TABLE end Much faster and simpler than hitting sysobjects
2003-05-29
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers