SQL Start up Script
This is a script that I run when SQL starts to notify me via email that a server has restarted as well as the location of the server.
2012-09-25 (first published: 2012-08-29)
1,845 reads
cluster
RE: Permissions and DBO question
Thank you one and all. I was a little leary about changing the DB owner to another Domain Account - even one that is a member of the local admin group and one that starts the Services. I kinda walked into a mess here and I have Databases 'owned' by 3 or 4 people that […]
2005-03-04
RE: shrinkdatabase
I understand that normally you should let your database activity determine the size of your log file ( assuming regular backups are happening ), rather than manually shrinking it's size on disk. However what about when DBCC SQLPERF(LOGSPACE) shows that the log really only needs a fraction of the disk space it is using? ( […]
2005-01-05
RE: Decorum in the Forums
Thanks Andy A couple here. http://qa.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=153039#bm153082 http://qa.sqlservercentral.com/forums/shwmessage.aspx?forumid=169&messageid=152271#bm152956 A couple of other limbo posts have been answered since I wrote my comment. It might just be the Christmas break, but you know how it is when you take the time to answer something, only to hear nothing and wonder whether the poster has even read it...
2005-01-04
RE: How to insert an image
Sorry, I'm not that much into VB anymore, but after reading your link, have you tried adVarLongBinary? But I think there are MS hosted newsgroups about VB and databases. Maybe worth a try to find a workaround if you don't want to change your app logic.
2004-12-02
Order by problem
When I say this :CREATE VIEW A AS SELECT NAME, NO,ADDRESS ,DESCRIPTION FROM TEST WHERE IS_TRUE='F' ORDER BY NAME I get the message as below :The ORDER BY clause is invalid in views, inline functions, derived tables, and subqueries, unless TOP is also specified. If i use Top n, I have to specify the n […]
2004-11-30
2004-11-18
RE: Creating Sql users from an Active Directory export
A few questions. Do you want to have all users have the same permission?If that is the case, you can just make NT Group from AD and add that NT group into SQL server.If you really really want to do, I think other people have better idea but my approch would be,1. import csv file […]
2004-09-28
2004-09-14
Equivalent of MS Access FIRST() function in SQL Server 2000
Hi,Is there any equivalent of MS Access FIRST() function in SQL Server 2000?I am looking for a workaround of FIRST function in SQL Server. Please help me out.Bye,Kamalanathan T.
2004-09-14
347 reads
Blogs
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...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
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