Hello Everyone, Is it possible to save the spanish characters in sql database? Thanks. ...more >>

I have a server A and server B and had a linked server LS from A to B. I need to insert data into a table t1 that is located in server B.Table t1 has identity columns. So I am doing the following code DECLARE @SQL NVARCHAR(500) SET @SQL=N'set identity_insert t1 on' exec [LS].B.d...more >>

I have a lenthy select statement that produces one value. I neeed to take that one value and update a table where ROW ID = 1. How can I do this? ...more >>

Can anyone help me work out what is wrong with this: SELECT dbo.tblManufacturer.web_manufacturer, dbo.tblProducts.itm_item, dbo.tblProducts.itm_desc, dbo.tblProducts.itm_wdesc, dbo.tblProducts.itm_wnotes, dbo.tblProducts.itm_price, dbo.tblProducts.itm_wpicture, d...more >>

Hi, i have quiz site and results of quizes stored in below table ----------------------------------------------------------------------------- TABLE [dbo].[sites_quizzes_results]( [quizid] [int] NOT NULL, [siteid] [nvarchar](50) COLLATE Turkish_CI_AS NOT NULL, [un] [nvarchar](50) CO...more >>

How to create a CLR DLL for Sql Server 2005? Is it just any .net class library that you can load into Sql Server 2005 or is there some special project type that I need to start with? ...more >>

hey all, i guess on sql express management studio i can't grant execute permissions to a user simply by right-clicking the stored proc. so can someone please how would i resolve this? thanks, rodchar...more >>

hi all I am using sql server 2000, and I created a view that joins about 5 tables for a report. However the view takes a really long time to return with results. How can I increase its performance. regards...more >>

Hello All, We have been using xp_smtp_sendmail for quite a few years. But, we are wondering what we should do 'going forward'. Our main EMAIL SERVER SERVICE requires SMTP AUTHENTICATION, and we can not do that with xp_smtp_sendmail. So, we setup a 'local' email server and do NOT requir...more >>

ID 1 plan value tag 510 10 0 2 510 35 0 3 510 23 0 4 520 13 0 5 520 15 0 6 530 23 0 7 530 12 0 8 510 10 0 9 520 10 0 10 510 13 0 Hi All, I have the data like my sample. I would like to mark the...more >>

I am not seeing the cache get invalidated; do I need to write a handler for the invalidate event? I though it was "auto-wired"... I run the application, then use SQL Server Managment Studio to change a row in the cached table. That should invalidate the cached copy? In the trace, two exece...more >>

Is it possible to retrieve the text of the TSQL command that caused a trigger? I've been asked to log this with our audit data for tracking..... I'm not seeing anyway to do it. Thanks in advance!! ...more >>

Hi, What is the best way to go about loading data into tables A and B if each has a trigger on it that checks for corresponding values in the other (an obvious paradox)? Must I disable the triggers or is there a better way to solve the problem? Perhaps my use of triggers in the first pl...more >>

hi. I need some help with this query. I want to extract the sum of payment amounts from an invoice table base on the last dates payments were applied. Sample Table XYZ: Invoice# Date Amt 1234 10/15 200 1234 10/5 1200 1234 10/20 600 1234 10/20 400 Th...more >>

I am getting a strange behavior using a cursor with an EXEC statement in a loop. the EXEC loop is repeating often and I am not sure why Here's what I have. Assume all variables declared no syntax problems: DECLARE @I_TableName varchar(25) DECLARE Insert_Cursor CURSOR FAST_FORWARD READ_ONLY F...more >>

Hi, I am getting error says "Cannot add rows to sys.sql_dependencies for the stored procedure because it depends on the missing table 'mystatus', the 'mystatus' is a stored procedure not a table which I created already, in my second stored procedure I have some like exec mystatus, @temp ...more >>

Is it possible to compute a string value for a field in SQL? For example, I want to take a last name field and a first name field and create a Full name field. Is this possible and if so, can someone provide a breif code example? I know a field can be a "computed field", but those seem to be f...more >>

Hi, I've always created my relationships between tables visually using database diagrams. The problem is that this is getting a little too slow for me as the number of tables grows, the diagrams is getting larger too. Is there any other way to create relationships other than using diagrams...more >>

Why I see table name and in brackets I see (dbo) How can I remove dbo? I would like to see only tables names. Thanks...more >>

Suppose I have two table, namely, "parent" and "child". parent table contains: EmpID DateA ===== ===== A01* 20/10* A07 19/10 A05 20/10 A02* 21/10* child table contains: EmpID DateTimeA ===== ========= A01* 20/10* 08:00 A07 21/10 09:00 A01* 20/10* 15:00 A01* 20/10* 20:00 A05 15/...more >>

How can do I create a function or sp to get a client computer name? How can do I create a function or sp to get a windows login name? Thanks jcp ...more >>

We want to locate the database folders/files (where the databases are stored) like SQL Server Management Studio UI does, when you click on Attach database -> Add. The question is how to retrieve (enumerate) these folders/files programmatically (VS2005, C#, SMO?). Practically we want to ...more >>

Hi, I am looking at building a column list from selected tables with dynamic SQL. ie. declare @clist varchar (8000) set @clist = '' select @clist = @clist + ',' + char(10) + 'inserted.' + column_name from information_schema.columns where table_name = 'tblname' is the a way to ...more >>

Is it not possible to use a 'select case' statement in SQL transact to = perform an action rather than a series of 'If, Begin, End' statements, = as you might do in VB? Example: declare @POLogID bigint, @AlertID int, @Value bit set @POLogID =3D 1 set @AlertID =3D 2 set @Value =3D 1 DECLARE...more >>

Hi there, I currently use this in a select statement: dbo.tblManufacturer.web_manufacturer + ' ' + dbo.tblSubCat2.SubCat2Name + ' ' + dbo.tblSubCat1.SubCat1Name AS [Product Name] The only problem is that when SubCat2Name is NULL nothing gets set, as you can not add NULL without getting NU...more >>

I have a requirement to present details of an event and the subsequent and previous events. An example, salesman visit towns. There is lots of salesman and they visit lots of towns. The request is to show for a town, say Town D, which town the salesman visited prior to TownD and the town he vi...more >>

hello please i need your help . how to got the tables of the system views. i want to know the views [database_role_members , database_principals] getting data from which tables. Thanks. Regards, Khaled ...more >>

Hi, SQL Server 2000 sp4 I receive the below error - any help would be appreciated! Command executed: C:\>bcp tempdb.dbo.RiskReversals10 in -n -i \\Sqlfx-uk\E$\ReplData\unc\SQLFX-UK_FX_FX\2007 1023065849\RiskReversals10_189.bcp -T Error: Error = [Microsoft][ODBC SQL Server Dr...more >>

Hello, I need to reduce a view to the latest 6 months. I want an indexed view so I cannot use getdate(). Is there a way to use a one-cell table holding a base date? I have tried but get this error: Server: Msg 107, Level 16, State 3, Procedure view_6m, Line 3 The column prefix 'dbo.tbl_setti...more >>

Hi! I have a date 'from_planned', which might be for example: '2007.02.13 14:33:10'. Now I want to get only the day and month part out of it, which is not so difficult: MONTH(from_planned) YEAR(from_planned) Now I want to get a date that would look like this: '2007.02.01 [00:00]' H...more >>