|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
SQL Server database programmingmicrosoft.public.sqlserver.programming
clustered index
simon -
18 Mar 2006 9:25 PM - 3 messages
I have question about clustered index. If you look at share point portal server database you will see, that primary key clustered index is composed of one unique identifier column and 2 columns of nvarchar(255) data type. Isn't that too long clustered index? ...
!! DOWNLOAD THE MOST POPULAR 2006's CRACKED SOFTWARE(CAD/CAE/CAM/EDA/PCB/GIS/CNC/FEA)
SoftStore2005 -
18 Mar 2006 6:39 PM - 2 messages
Our team provide different types of services such as: - proffessional cracking of any kind of software
(CAD,CAM,CAE,EDA,GIS,PCB,FEA,FEM,CNC,CFD,PDS,3D,Optics etc.) designed
for any kind of operating systems(Windows 95/98/ME/2000/XP, Linux,
FreeBSD, OS/2, MAC OS etc.) ...
conditional update within value
JR -
18 Mar 2006 6:28 PM - 3 messages
I have a column of data in SQL Server 2000 that I need to replace values within it with new values. I know how to use CASE statements to do conditional updates but not how to do this. Here is an example, not ...
Backup and Restore with STOPAT
George Homorozeanu -
18 Mar 2006 5:26 PM - 4 messages
Hi I want to implement the following simple scenario as a test prior the real implementation to see if these scenario is plausible. I want to test the STOPAT option of the RESTORE LOG command. 1. First I want to full backup the database (the "Recovery model" ...
Log Shipping Question
Ed -
18 Mar 2006 5:16 PM - 2 messages
Hi, I would like to implement Log Shipping to my company and I have everything set up and work fine. However, I am not sure how to ship the database backup file to the destination server after the first time. Since the log shipping ...
¤ China ZhongZhan Aids Mei Mei
enlamasperm -
18 Mar 2006 4:41 PM - 1 message
Killer! [link] el***@digi-art.de ...
¤ China ZhongZhan Aids Mei Mei
enlamasperm -
18 Mar 2006 4:41 PM - 1 message
Killer! [link] el***@digi-art.de ...
optimized indexing 1
Sinclair -
18 Mar 2006 4:16 PM - 1 message
Hi, I apologize to ask again. Related to the example in previous question about optimized indexing, should there be changes in proposed indexes, if the field [family name] takes part in INNER JOIN with some other table (Foreign key)? thanks Sinclair ...
Re: import txt file wizard
John Bell -
18 Mar 2006 4:10 PM - 1 message
Sent this before I finished! You will need the Import Data item from the Tasks menu and choose Flat File as the source. John ...
optimized indexing
Sinclair -
18 Mar 2006 3:56 PM - 2 messages
Hi, I would like to consider optimized indexing on the table which really does not exist in my database, but will serve as an example for creating indexes. Suppose that there is a table with following fields: - family name, - first name, ...
Hebrew Sql 2000 to 2005 Collation Problem ?
D.R -
18 Mar 2006 2:01 PM - 5 messages
Dear Gurus : i have a database on sql 2000 server with default Collation set to ( British English ) and the databse have hebrew character inside and everything works great now that microsoft comes with the new sql we deatach the database from ...
UNABLE TO SEE SYSTEM TABLE IM NY ENTERPRIsE MANAGER
Savas Ates -
18 Mar 2006 11:43 AM - 4 messages
When i choose my database in enterprise manager i cant see my system table ? What is the setting to see them ? ...
Delete and insert data in same transaction!
Hans -
18 Mar 2006 10:24 AM - 7 messages
Hi! I try to add records in one table from a VB6 com+ component using ADO (provider=SQLOLEDB, SQL-server2000). Basically what I try to do is to 1. Start a transaction 2. Delete old records in one table 3. Add new values in the same table ...
Change Field Name
Agnes -
18 Mar 2006 10:14 AM - 2 messages
I got 30 tables and I want to change one field name , Can I use SQL script to do that ? Thanks a lot . ...
MOVING FROM ACCESS TO SQL
alami_marieme@hotmail.com -
18 Mar 2006 10:06 AM - 5 messages
Hi could anyone help please...I've problems moving my database from Access to SQL specially with tables relationships...Here is the probl:I have a form having the Order number, order date, client code...this information is taken from table BLA.on the same form,I've a subform ...
About images and audio waves
Raheel Ahmed -
18 Mar 2006 8:43 AM - 1 message
Hello All of you ! I have never worked on images and audio in SqlServer database with C#.NET as a front-end tool. Can you help me by sending the code of how to store and retrieve the ...
**fetch the related tables of a particular table**
R-M -
18 Mar 2006 7:53 AM - 2 messages
Hi I'm working with SQL server 2000, and I want to know how can I find the list of tables which have relation to a particular table. in another word, would it be possible to fetch the name of those tables by a simple Sql ...
Re: Not able to Export data from data file
The RelentlessOne -
18 Mar 2006 4:50 AM - 1 message
See if CompareRocket for Visual Studio can get you around the issue. It has a free trial for 30 day. You can find it at [link] subrat_pani <member31***@dbforums.com> wrote in news:3061041.1057042717 ...
Query question
joel -
18 Mar 2006 4:44 AM - 3 messages
Hi All, I have a problem with my query. I want to get the 2nd occurences of space after the comma(,) sign. I have a query but only works if the city/area is one word. example: correct SELECT CHARINDEX(' ', 'Atlanta, GA 1234', CHARINDEX(' ', 'Atlanta, GA ...
Question AGAIN!!
DavidW -
18 Mar 2006 3:54 AM - 3 messages
Which is better VB Express or making a local web based application? If I choose to run a web based app from within our local network only, not out in the www, would i have to run another server to run the web app or ...
Re: Performence
The RelentlessOne -
18 Mar 2006 12:20 AM - 1 message
Try the demo of SQL Optimizer for Visual Studio. It should solve your problem [link] $a0012***@phx.gbl: ...
Multiple Joins Showing Wrong # Records
BenM -
17 Mar 2006 11:09 PM - 3 messages
I have a query that I need to return 478 rows, which is the number of records in one of the tables. The problem is that I have to join more than one table to the query, and I only get the rows that have data, whereas I would prefer ...
Creating a view with multiple join criteria
epikto -
17 Mar 2006 10:57 PM - 3 messages
This is a silly question but i must present it. I am creating a view between two tables. Both tables are identified by two pieces of data: User ID and Product Name fooshly those who created the tables did not create the Product name to ...
design question
ChrisR -
17 Mar 2006 10:22 PM - 6 messages
Howdy all. I have developers wanting to design a table that will hold not only client info, but what type of program they are eligible for. I have narrowed it down to 2 options, but was really looking for opinions. The ...
SQL Jobs Fail but give no error
Andrew -
17 Mar 2006 10:09 PM - 10 messages
Hey all, Running into a first for me here..... I 'inherited' a SQL Server as part of my new job and there are some quirks happening that I have never encountered before. I am not a full fledged DBA, yet I thought myself at least fairly ...
getdate()
Curtis -
17 Mar 2006 9:50 PM - 5 messages
Nothing I do changes the format of the date. declare @PubDate datetime set @PubDate = convert(varchar,getdate(),111) SELECT @PubDate,* FROM OPENquery(MySQL, 'SELECT * FROM articles WHERE Weight = 3 AND ...
Please Help: SSIS Package execution issue
RSH -
17 Mar 2006 9:29 PM - 1 message
I have created a DTSX SSIS Package that is quite simple in nature (a simple export). I can double click on the DTSX package on the server and the Execute Package Utility launches and executes the package to completion ...
import txt file wizard
ChiWhiteSox -
17 Mar 2006 9:21 PM - 3 messages
where did the import txt file wizard go in sql 2005 ?? i used to just right click on the data base / tables then sleect import / export. any ideas??? thanks! ...
An Insert Trigger with CDOSYS generated email
Marcial -
17 Mar 2006 8:20 PM - 5 messages
Hello, I've got an insert trigger defined on a table. Everything seems to work perfectly excpet the body section of my e-mail message is delivered empty. Here the relavent code segment... Begin DECLARE @CaseCounter varchar(50) If (SELECT Count(*) FROM inserted WHERE PI_ID = '0000') >0 ...
Change Column Names
Chris -
17 Mar 2006 7:54 PM - 2 messages
Can someone help with a query to change the column names in a table Thanks Chris ...
Vb.NET
Neo -
17 Mar 2006 7:28 PM - 6 messages
is there any reason why a sql command will execute in sql server and not in Vb.Net? It takes about 1.5 minutes to execute.. Would the timeout have anything to do with it? If so how do I increase it? ...
Re: Server Explorer in VS.Net
The RelentlessOne -
17 Mar 2006 6:47 PM - 5 messages
You can try CompareRocket for Visual Studio. From it you can not only get the create scripts but also going forward to you can get upgrade scripts. [link] ...
Huge amounts of unused space...why?
Robby -
17 Mar 2006 6:44 PM - 7 messages
I've got some tables that are growing very large and the vast majority of the space is unused space...take for instance: Table 1 rows = 161,000 reserved = 2,542,064 KB unused = 2,162,784 KB data = 357,952 KB ...
Update Trigger Question
Tim Bryant -
17 Mar 2006 6:24 PM - 4 messages
This might seem really simple or silly..... If I set up an UPDATE trigger against a table (eg. Table A) and the T-SQL code goes off to find some value from another table (eg. Table B), which is used to update a field in the original table (Table A), does the trigger ...
For XML Explicit in a stored proc
john.wilker -
17 Mar 2006 6:21 PM - 2 messages
I searched and searched and didn't see what (i think) i need for a solution. Here's my situation. SQL 2k5 Stored Proc with set @XMLFile = ( SELECT 1 as Tag, ...
Articles or Blogs
skg -
17 Mar 2006 6:19 PM - 4 messages
I am aware how symmetric and assymetric keys are used in sql. Can some one point me to good articles on what are symmetric and assymetric keys ?. thx ...
Solution needed Urgent...
Jason -
17 Mar 2006 5:52 PM - 1 message
Hey Gurus Can you give me a clue to how to do the produce the following Output from below table. insert into Q2 (Emp_name,Category,StartDate,EndDate) Select 'John', 'A10', '19961001','20000807' Union Select'John', 'G20', '20000803','20000815' Union ...
An alternative for Dynamic SQL required
Tejas Parikh -
17 Mar 2006 5:05 PM - 4 messages
Hey guys I've something like this which is a reauirement. I dont want to use a dynamic SQL eg is create proc proc1 @ownername varchar(100), @IPaddress varchar(15) as select a,b,c from Table1 t1 join Table2 t2 on t1.col1=t2.col2 ...
How to get varchar parameter in Extended stored procedure
nick -
17 Mar 2006 4:38 PM - 2 messages
I have the following code to read the varchar in parameter. However, srv_convert function sound doesn't fill the temp variable. It remains the testing 'aaaaaaaa...' string. Any clue? Thanks. char* temp = new char[8000]; ...
Get return value of stored procedure in Query Analyzer
dw -
17 Mar 2006 4:08 PM - 5 messages
Hi. We've got a stored procedure on SQL Server 2000 with a Return statement, and sending back a number. Is there a way to view the Return value when executing this procedure in Query Analyzer? Right now, it's just displaying ...
simulate infinite loop
chieko -
17 Mar 2006 4:01 PM - 6 messages
Hello everyone, I would like to run a select statement every nine seconds 24 hours a day, 7 days a week, 365 days a year unless I physically stop the select statement myself. Currently I have a while loop that runs 89 or 90 times with a wait for ...
obtaining the names of triggers within T-SQL
Brian Cobb -
17 Mar 2006 3:55 PM - 7 messages
I have a db containing 2 base tables and a view with an INSTEAD OF INSERT trigger that updates both tables. I want to prevent inserts on the base tables themselves with an INSTEAD OF INSERT trigger that would raise an error ...
text to varchar conversion woes
Stephan Steiner -
17 Mar 2006 3:52 PM - 3 messages
Hi I can't quite decide which is more annoying, string manipulation in plain ANSI C without any helper libs, or in T-SQL. I've figured out the copy text from one to another table, now I have to conversion problem. ...
How to save an HTML doc in SQL 2005
Paul -
17 Mar 2006 2:45 PM - 7 messages
I would like to save an HTML doc in a column of a SQL 2005 database. However, in order to make it more legible, there are carriage returns ...
Compare subsets
Neo -
17 Mar 2006 2:07 PM - 2 messages
Hello, Does anybody know how to compare the subsets of two columns on different tables? We have a column A in Table A that we want to compare any 10 characters to column B in Table B. Does anybody know the code to do this? ...
Search for newline chr
Craig -
17 Mar 2006 1:34 PM - 5 messages
Hi, Could someone tell me how I might search for a newline character in a particular field? Many thanks, Craig ...
Indexed view
simonZ -
17 Mar 2006 1:19 PM - 2 messages
I created view: CREATE VIEW dbo.v_test with schemabinding as select s.productID,sum(s.productQ)as quantity FROM dbo.invoice i INNER JOIN dbo.sell s ON i.invoiceID=s.invoiceID WHERE s.productID is not null AND i.status<3 ...
how to debug the stored procedure in sql server
shiva -
17 Mar 2006 12:08 PM - 2 messages
hi! all, i have a problem , i want to debug the stored procedure in sql server. help me thanks in advance shiva ...
moving from Access to SQL 7.0
alami_marieme@hotmail.com -
17 Mar 2006 11:06 AM - 6 messages
Hi all could anyone pleeeeeeeeeeease help I have big problems moving my database from Access to SQL 7.0... I had an Access database having queries, forms, and reports linked to another Access database having tables. Now, I'm moving my tables to SQL ...
executing a trigger
Robert Bravery -
17 Mar 2006 10:47 AM - 4 messages
HI all, is the only or perhaps the best way of executing a tables trigger via another trigger or SP by actually updating said table I have a calulation in table a update trigger. It is based on related values ...
updateable and non updatable rows
Robert Bravery -
17 Mar 2006 10:33 AM - 3 messages
HI all, How can I ensure that a row is updatable or not updatable based on a bit colum of that row. So that if the bit value is 0, then that row cannot be updated, and vice-versa THanks ...
transpose
Rein Erm -
17 Mar 2006 10:25 AM - 5 messages
Hi In MS Excel exists function TRANSPOSE. Is there any possibility to do the same in SELECT-query with T-SQL? Explanation: Table with 3 fields: Name / Age / Weight Carl / 15 / 172 Eva / 44 / 155 I want to show this data to user so: ...
Maximum Rowsize screw up by MSSQL 2000
Sven Peeters -
17 Mar 2006 7:46 AM - 4 messages
I've got a table that has too many fields to fit on one page ( So i get that warning when adding fields ). Most of those fields were added after the creation of the table. When I try to edit a record, I get the maxrowsize error. ...
Alternative to OpenXML
Shilpa -
17 Mar 2006 7:46 AM - 2 messages
Hi, I want to entere data in xml into tables in the database. Howevere, I do not want to use OpenXML Please let me know if there is an alternative. Regards, Shilpa ...
Dates Help Needed
Jason -
17 Mar 2006 7:39 AM - 5 messages
Hey Gurus Can you give me a clue to how to do the produce the following Output from below table. insert into Q2 (Emp_name,Category,StartDate,EndDate) Select 'John', 'A10', '19961001','20000807' Union Select'John', 'G20', '20000803','20000815' Union ...
Optimal storage of a lot of text records
Ward Bekker -
17 Mar 2006 7:11 AM - 14 messages
Hi, I have the availability of a database of 100mb. I need to store large amounts of forum messages, the more the better.Currently every table row has 4 small nvarchar fields, and a ntext for the body of the forum ...
Need help with the SELECT statement please.
Lam Nguyen -
17 Mar 2006 5:19 AM - 3 messages
Hi all, Can you somebody help me with the sequel statement below please? The business rule is describe below and the result want show below too. Thank you very much in advance. IF OBJECT_ID('Tempdb.dbo.#Prospect', 'u') IS NOT NULL ...
DB Collation
Dragon -
17 Mar 2006 4:57 AM - 4 messages
Can I change DB Collation after it is created ?? ...
predicate [ ] using xml in sql server 2005
supriya -
17 Mar 2006 4:32 AM - 2 messages
Hi , I have a doubt using xml in sql sever 2005. I found in many places while specifying Xpath ,the predicate contains '1' like /Inst:root/Inst:Location[1]/Inst:step . I tried with some other numbers in predicate like ...
Problem with Date logic
Vear -
17 Mar 2006 2:47 AM - 4 messages
Hi OK, Here goes. I have a booking table with a Checked In Date and a Checked Out Day. I have a user input screen where a user Chooses a checked in date and checked out date. I want to know if any rooms are available so I check against the ...
T Sql Help
Jason -
17 Mar 2006 12:55 AM - 7 messages
Hi All SQL GURUS here is my problem, Below is the table Create table Q3(Name Varchar(30),Specialty Varchar(30),Section Char(1)) Insert into Q3 Select 'Ram', 'Director','A' Union Select 'Ram', 'Adviser','A' Union Select 'Ram', 'President','B' ...
TSQL Complicated query
Rajesh -
17 Mar 2006 12:30 AM - 3 messages
Hi Sql Gurus, SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[temptable123]([name] [varchar](50) NOT NULL, [start_dt] [char](8) NOT NULL, [end_dt] [char](8) NOT NULL, [rownum] [int] IDENTITY(1,1) NOT NULL, ...
Solution Required Immediately
Jason -
17 Mar 2006 12:24 AM - 3 messages
I need to create a query for the below situation the table is as below Department Month Category Sub_Category Code ...
Double Quotes and Print
Meher -
17 Mar 2006 12:07 AM - 6 messages
Hi: This is a very simple thing but some how i have a mental block. what I am trying to do is concatenate a string that gets passed with double quotes to a single quoted string and trying to print but I get an error. here is what I am ...
Culture in MSSQL 2005 express edition
michael -
16 Mar 2006 11:32 PM - 3 messages
i am trying to add xml to the xml data type column. The xml contains both english and hebrew characters. English characters are saved well, but hebrew saved as "???????????" how can i fix it? ...
Using Temp DB vs a standard db for work area
sqlboy2000 -
16 Mar 2006 10:01 PM - 4 messages
Does anyone know if there is any performance gain or hit by using temp db vs. a "standard" database as a work area? For example, I'm extracting 2 columns from a normal table and creating a temp table that I perform various ...
Application for "Replaying" a Table
chrison600 -
16 Mar 2006 9:40 PM - 1 message
I'm on a quest to find a way to "replay" a selected time range of records from a table. The purpose is to simulate the pace and content of the records in the table exactly as they were parsed during run-time. The ideal solution ...
aggregate query reporting different results
jason -
16 Mar 2006 9:36 PM - 2 messages
forgive the absense of DDL and data to reproduce this problem, but it is 8 tables and hundreds of thousands of rows of data. instead, let me just post the query and the symptom and we'll see how far that can get ...
Return a Field from a User Function ??
Gilles Labelle -
16 Mar 2006 9:23 PM - 2 messages
Hello, I am using SQL Server 2000 and I am wondering if it possible to create a user fonction that return a field so I can use the return of the function in a WHERE . My original query I someting like this: ...
The best way to connect to SQL Server from C++
xcppcoder -
16 Mar 2006 9:20 PM - 3 messages
Hello All I want to connect to SQL Server from Visual C++, and I'm wonder which technology is best to use (ODBC, ADO, ...)? Thanks in advance. ...
bcp right truncation: how to ignore
mudassir.latif -
16 Mar 2006 9:09 PM - 3 messages
Hi, I'm trying to upload a large number of log entries currently stored as text files into a database table using bcp. For a few rows I get a "right truncation" error and the offending rows are not uploaded to the ...
database diagrams
Richard Kohler -
16 Mar 2006 9:08 PM - 3 messages
Using SQL 2005, I am not able to access existing database diagrams created in SQL 2000. It tells me there is no valid owner for the database and can not install the diagram support objects. The database properties say SA is the ...
Top N worst groups SQL problem
ccjjharmon -
16 Mar 2006 7:45 PM - 8 messages
Here is a ricky little problem I cannot figure out, and am hoping someone can help. We have a need to get the Top N "worst" groups, and the data that we have to determine "worseness" can only be measured at a level below the ...
How to insert resultset from SP into a table? or use Select * From
Rich -
16 Mar 2006 7:40 PM - 4 messages
I tried this (and other variations) in Query Analyzer - which did not work. select * from (exec stp_Report_MonthlyCountHistory_Summary '24', '%', '3/13/06', '3/13/06') Is there a way to Select/insert the resultset from an SP? How to do this? ...
table name as variable
Bahman -
16 Mar 2006 7:39 PM - 4 messages
Hello! The SP does not take table names as variables. But it takes variables for conditions, return values, and such. I have different tables depending on the case. I could merge them just for this purpose or create multiple SP. Otherwise, somehow I need to tell the SP ...
Audit Table - Design Question
Jim Underwood -
16 Mar 2006 7:36 PM - 3 messages
I am looking for feedback on how to best design an auditing database for tracking the progress of a file through various applications and vendors. We need to be able to track delays in processing, as well as lost or missing ...
SQl Profiler
Naveen -
16 Mar 2006 7:07 PM - 3 messages
Is it possible to create a profiler with execution plan for specific procedures? In production server I want to capture execution plan for specific proc. ...
SQL Server 2000 Automatic Setup Script.
Matthew -
16 Mar 2006 6:47 PM - 5 messages
I need to set up a lot of SQL Server, and Right now I have to go in by hand and configure some of the options. I want to know if there is a way I can just run a script that will take care of all these options. ...
SSIS and ragged rows (variable number of columns)
dianos -
16 Mar 2006 6:14 PM - 1 message
DTS used to work fine with comma delimited files like this 1,2,3,4,5,6,7 1,2,3 1 1,2,3,4,5,6 1,2,3 (my real data has up to 90 columns, and millions of rows...) ...
Replacing specific text characters in a TEXT field with CRLF characters
benedick96 -
16 Mar 2006 6:11 PM - 4 messages
In SQL Server, when you have a TEXT field, it can store some long-text. You can also insert a CRLF in the text so that it displays with a CRLF on-screen and when printed. I am using a customized program to import data into SQL Server (a ...
SQql 2000 Nested Loop
Paul -
16 Mar 2006 5:44 PM - 1 message
I need to create a nested loop T-Sql store procedure for a dataset for a report and I am not sure how to do this. I have a data warehouse database consists of the Customer's Contact and Purchase information such as "First ...
Which primary key
Andy Furnival -
16 Mar 2006 5:30 PM - 6 messages
Hey Guys and Gals, I've run into a rather odd table design stump. I have a basic customers table, and in this table I store various information for each customer and some customers more information than the others. ...
list of tables and views in a database
J055 -
16 Mar 2006 5:25 PM - 4 messages
Hi Can someone tell me the best way to extract a list of table names and views from a database in a select statement? I'm using SQL Server 2000. Many thanks Andrew ...
Aggregating bit data types
mike -
16 Mar 2006 5:20 PM - 4 messages
Hi. Consider the following DDL: CREATE TABLE [TableB] ( [TableB_ID] [int] IDENTITY (1, 1) NOT NULL , [TableA_ID] [int] NULL , [Flag] [bit] NULL CONSTRAINT [DF_TableB_Flag] DEFAULT (0), CONSTRAINT [PK_TableB] PRIMARY KEY CLUSTERED ...
Table variable and statitics on it
Scott M -
16 Mar 2006 5:15 PM - 3 messages
I'm using a table variable in some SQL query (Trying to listen to all the best practices :) ) and I am looking at the execution plan that was used in the query. My table scan step on my table variable is red (Missing ...
Estimating time for creation of clustered index
ionFreeman@gmail.com -
16 Mar 2006 5:02 PM - 2 messages
I asked my SQL Server to create me a clustered index on a 200,000ish row table. It's taking rather longer than I expected. But, I don't really know how long I should have expected it to take. How can I ...
Question about LIKE and wildcard operator (%)
Alex -
16 Mar 2006 4:56 PM - 4 messages
Hi all, Given the following code: DECLARE @param nvarchar(100) SELECT @param = '[STRING1][STRING2]' SELECT CASE WHEN @param LIKE '%[STRING1]%' THEN 'yes' ELSE 'no' END AS Test1, CASE WHEN @param LIKE '%[STRING2]%' THEN 'yes' ELSE 'no' END AS Test2, CASE WHEN @param LIKE '%[STRING3]%' THEN 'yes' ELSE 'no' END AS Test3 ...
Running the same SQL on several servers
CJM -
16 Mar 2006 4:36 PM - 2 messages
I frequently do updates to Stored Procedures (and other types of SQL queries too) on serveral server installations across our LAN/WAN. Currently, I connect to each server in SSMS and run the code in a new query window for each, which is a bit of a pain. Is there a way I can run the ...
Linked Servers
Alastair MacFarlane -
16 Mar 2006 4:07 PM - 2 messages
Dear All, I am trying to link 2 servers together and get the following message: Server: Msg 18452, Level 14, State 1, Line 1 Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. If I query MyServer and OtherServer independantly I can see the expected ...
PID in VHDL code
aramis -
16 Mar 2006 4:06 PM - 2 messages
right now I'm using ALTERA MAX+PLUS II version 9.23 Baseline. actually
part of my task is to do the programming in the VHDL software (ALTERA
MAX+PLUS II) and then download it in the hardware called FPGA. however, due to
time ...
SSIS Package not executing as SQL Agent Job
RSH -
16 Mar 2006 4:04 PM - 1 message
I have created a DTSX SSIS Package that is quite simple in nature (a simple export). I can double click on the DTSX package on the server and the Execute Package Utility launches and executes the package to completion ...
Convert date to year
Sarah -
16 Mar 2006 3:15 PM - 5 messages
Hi, I'm using sql 2000, and I like to know how to convert current date to year (eg. 2006). Thanks, Sarah ...
Primary Key fields require index?
Cipher -
16 Mar 2006 3:05 PM - 4 messages
Whenever you define a Primary Key on a table in SQL Server 2000/2005 my understanding was that this implicitly created a index for all the fields in the Primary Key. Therefore, as far as I'm aware, it would be redundant to ...
How to Copy the User
Nizham -
16 Mar 2006 2:51 PM - 2 messages
Hi There are two different server A and B both are isolatted. Is there is any way to copy all the user under security login of server A from Server B Regards Nizham ...
Where are Default Values stored
Alan Jackson -
16 Mar 2006 2:44 PM - 6 messages
Hi I'm wanting to check to see what value has been stored for a default value, but I can't find where the default itself is actually stored. I've found the object in sysobjects, and I can see that the columns that are ...
Validate the text field in the sql server
Good -
16 Mar 2006 2:38 PM - 4 messages
Hi all Is it possible to validate the text field in the sql server to make sure all of the text are Chinese words? And the "English" Text field could only allow the English word only and have no Chinese words? ...
NEED HELP W. QUERY USING DISTINCT AND SUM AND CASE
suslikovich -
16 Mar 2006 2:34 PM - 8 messages
Hi everyone, I am having a problem writing a query to get people from a db that we designate as Anonymous (those who don't have firstname, lastname, accountid but have propecids) and those who we call Named (they have ...
Update trigger during large updates
Mike -
16 Mar 2006 2:32 PM - 3 messages
I have 2 update triggers on a table. If one of my query is updating 3000 records in that table, will the trigger kick in once or while it kick-In 3000 times? Also, is there a way to determine the which trigger (of the two) should ...
migrate a 600GB of DB from State to State.
Naana via SQLMonster.com -
16 Mar 2006 1:33 PM - 3 messages
Hi All, What will be the best practise to move a 600 GB of a database from one state to another, if data needs to be available all the time. Thanks. ...
Error (8626) while inserting record into table with text field and which is the base for indexed vie
How to set sql server setting let to set null value when a empty string (zero length) set to column?
Next »
|
|||||||||||||||||||||||