Technical Article

RE: Permissions and DBO question

  • Reply

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 […]


Technical Article

RE: shrinkdatabase

  • Reply

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? ( […]


Technical Article

RE: Decorum in the Forums

  • Reply

Thanks Andy A couple here. 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...


Technical Article

RE: How to insert an image

  • Reply

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.


Technical Article

Order by problem

  • Topic

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 […]



Goal Progress for Jan 2023


The grade for January is a D. Details below, but just not making a...

Context Info Across Databases–#SQLNewBlogger


Does Context Info work across databases? This post shows it does. Another post for...

Introducing… Data On Rails!


Data On Rails is a Data On Wheels project designed to give a platform...

Read the latest Blogs


Storing a text file in a VARCHAR(MAX) column

By Mick Opalak

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

By Edub1122

I have two tables: tblProfessors with ProfessorID as the primary key and tblStudents with...

blocking issue

By vsamantha35

Hi All, We are seeing SELECT's blocking DML's like UPDATE statements. When we tried...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers