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,854 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://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=153039#bm153082 http://www.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
392 reads
Blogs
Goal Progress for Jan 2023
By Steve Jones
The grade for January is a D. Details below, but just not making a...
Context Info Across Databases–#SQLNewBlogger
By Steve Jones
Does Context Info work across databases? This post shows it does. Another post for...
Introducing… Data On Rails!
By DataOnWheels
Data On Rails is a Data On Wheels project designed to give a platform...
Forums
Storing a text file in a VARCHAR(MAX) column
I'm using OPENROWSET to put the contents of a text file into a VARCHAR(MAX)...
"ID" primary key from two separate tables as a foreign key in a new table
I have two tables: tblProfessors with ProfessorID as the primary key and tblStudents with...
blocking issue
Hi All, We are seeing SELECT's blocking DML's like UPDATE statements. When we tried...
Ask SSC