RE: Restoring system databases to different SQL Edition
I haven't tried this either, but if the SP levels are the same I'd guess it would work. I have had issues restoring an SP3 master to a lower level server.
2004-01-29
hardware
How to change the user name from dbo
The user is one of the DB owners and currenly appears in the system as DBO. All the tables he creates any named as DBO.TABLE.He however wants to appear under his regular personal NT account name to create PERSONAL.TABLE and to have all existing objects to be renamed automatically.How can we do that?
2004-01-26
1 reads
Which SQL Server License to buy ?
Hello we are about to purchase an SQL server license but are not clear as to which licencing scheme to go for. We will be hosting only one site on the online server and only the development team will access the SQL Server to make any alterations. Under this situation should we buy 1) SQL […]
2004-01-26
RE: Declaring local variable larger than 8000 characters
Use multiple output variables, each with a piece of the query being built, and then concatenate those variables in the EXEC() in the calling proc.
2004-01-23
1 reads
RE: Worst Practice - Bad Connection Strings and Bad Info in Sysprocesses
Nice enhancement. I have several components that are running and I would like for the same connection change the 'Application Name'. It seems that this is a read only parameter. Do you know by any chance if there is a way to change the application name or another property that could be used so that […]
2004-01-22
RE: Need syntax help
Hello and thank you for the suggestions. You are absolutely correct about my error. My code, as posted, results in an error stating that the group by expressions must refer to column names that appear in the select list. If I remove the group by I get invalid column name PID.PQty. I just tried your sample […]
2004-01-14
RE: Parmeterized list to a stored procedure
I didn't read the article, so I'm not sure that what you mean by parameterized list is what I think of when I hear parameterized list.A parameterized list to me means a list of parameters. When you create a stored procedure, you can add parameters to it. Like so:Create Procedure dbo.MyProcedure @Parameter1 int, @parameter2 varchar(50), @Parameter3 sysname, […]
2004-01-09
1 reads
RE: Connecting to SQL Server Using a 'trusted id'
Jonathan, Application roles would work for a couple of the applications, but most hit more than one database. Thanks anyway.
2004-01-02
2 reads
RE: GREAT 2004 and FORWARD MARCH
Agree and thanks for the note. Thanks to all for their contributions and thanks that my family, friends, and partners are healthy! Steve Jones sjones@sqlservercentral.com http://qa.sqlservercentral.com/columnists/sjones The Best of SQL Server Central.com 2002 - http://qa.sqlservercentral.com/bestof/ www.dkranch.net
2003-12-26
1 reads
RE: Transaction Log Growth
Also, if I setup the alert, will it write to the event log? We use a product called ELM that sweeps the event log and notifies the appropriate personnel. Terry
2003-12-17
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