database administration

query parms in email subj

• by Site Owners

• SimpleTalk

• Reply

No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!

2005-04-29

RE: Question of the Day for 06 Apr 2005

• by happycat59

• SQLServerCentral

• Reply

I think the correct answer really is NONE OF THE ABOVE. Your first step really should be to determine what the security requirements are. Otherwise, you will simply launch Analyis Manager and then what access to you give to this user ?

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2005-04-06

sql 2005 beta 3

• by Yoav-S

• Brent Ozar Unlimited Blog

• Topic

Hi all,When I am trying to create a new Maintplan in sql2005 Beta3 I get this error:TITLE: SQL Server Management Studio ----------------------------------------Exception has been thrown by the target of an invocation. (mscorlib)---------------------------------------- ADDITIONAL INFORMATION:An OLE DB error 0x80004005 ([DBNETLIB][ConnectionOpen (PreLoginHandshake()).]Encryption not supported on SQL Server.) occurred while enumerating packages. A SQL statement was issued and failed.I […]

2005-03-22

3 reads

UDF Problem

• by Robbs

• SimpleTalk

• Topic

I have a table that has 2 fields where the data values need to be calculated. To do this I created a UDF that does the proper calculation and binded these to their respective fields in the table. The problem is that one of the UDF's requires input from the field that gets its value […]

2005-03-21

1 reads

RE: Trigger talk- Need some assistance

• by dba_dave

• MSSQLTips.com

• Reply

Thanks Remi!  I'll give it try. 

2005-03-18

RE: variable in the FROM clause

• by rhunt

• Brent Ozar Unlimited Blog

• Reply

declare @selField varchar(50) declare @selTbl varchar(50) declare @sql varchar(100)set @selField = 'name' set @selTbl = 'sysobjects'SET @sql = 'SELECT ' + @selField + ' from ' + @selTbl EXEC(@sql)

2005-03-18

Re: Problem in inserting a row

• by AJ-92543

• SimpleTalk

• Topic

Hi all,I like to insert a row from a table back into the same table.  In another word I want to duplicate the same record in the table in the stored procedure but it is generating the error below.  There is identity column in the table but I'm why I can't insert a row and […]

2005-03-17

2 reads

RE: Copy SP

• by Frank Kalis

• SQLServerCentral.com

• Reply

INSERT INTO tbl2 (fname) SELECT fname FROM tbl1 WHERE ref#='123'Btw, the # sign isn't really good to be used as a column name. I have seen several threads here, where this caused more or less severe problems.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2004-12-16

RE: Do I still need Business Objects??

• by HelpMeInOhio

• SQLServerCentral.com

• Reply

Thanks ! for the info.  I'll pass anything I learn new along here.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2004-12-06

RE: System Tables and View Fields

• by hoo-t

• SQLServerCentral.com

• Reply

OH!  You can script a view, and get the source columns/tables that way.  In Enterprise Manager, right click, all tasks, generate SQL script.  Click "Show All", select your view from the list and click Add.  Then click Preview to see the script.  Or in Query Analyzer Object Browser, right click and script to new window.  Steveedit... […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2004-11-22