Hi all, I have tried to create an asembly with PERMISSION_SET = EXTERNAL_ACCESS under SQL Server 2005 but i failed so far. I also see the TRUSTWORTHY Property for the database as disabled and can't enable it. I know that the sysadmin has the full authority for all activities, but i'm logged ...more >>

I'm using SQL SERVER 2000 and in the process of establishing recovery guide. Tried to rebuild master using rebuildm.exe but the "Configuring Server" never ending. Then I tried to copy original databases from SQLServer Installation CD to hard disk as the "Browse for folder", but gave the same pr...more >>

Hello everyone. I need help regarding the following: Given the following table: CREATE TABLE T1 (C1 nvarchar(10), C2 money) INSERT INTO T1 VALUES ('A',1) INSERT INTO T1 VALUES ('B',2) INSERT INTO T1 VALUES ('C',3) let's say that i have this table in a local server and i want to upload i...more >>

I am trying to create a SQL statement that returns values from fields in the database but I also need to return values that are NOT in the database but hard coded int he SQL statement. The values along with the names of the fields will be hardcoded into the SQL statement. I'm not sure if this ca...more >>

Hi all, Is there any way I can know who Disabled a Job?? bye. ...more >>

Hello, I have an XML data feed that I would like to use to create tables in SQL Server. The xml data feed consists of a large amount of information that changes on a regualar basis. Is there a way to automatically create SQL Server tables using the data feed? Thanks Billy ...more >>

Follow the directions below and in two weeks you'll have up to $20000.00 in your PayPal account. There is a very high rate of participation in the program because of its low investment and high rate of return. Just $5.00 to one person! THAT'S ALL !!! If you are a skeptic and don't think the...more >>

I sometimes get the following error from an update statement in a stored procedure: Transaction (Process ID 62) was deadlocked on thread | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction. The isolation level is READ UNCOM...more >>

We have a software assurance contract, and we get our media from a Microsoft Certified Partner. Our MCP hasn't been able to provide us with media for SQL Server 2005. It's been 7 weeks since the launch; I expected the product to be in the channel by now. Anybody else (especially software a...more >>

The SQL SERver 2005 Standard Edidtion install CD and the MSDN CD distributed at the SQLServer Launch in Chicago are blank. Has anyone else had this problem and or requested replacements? If so, how. thanks much Mo ...more >>

Does this make sense for a logon table: CREATE TABLE Logon ( ID INT NOT NULL IDENTITY PRIMARY KEY, name VARCHAR(15) NOT NULL, password VARCHAR(15) NOT NULL ) GO CREATE UNIQUE INDEX IX_Logon_Name ON Logon(name) CREATE INDEX IX_Logon_NameAndPassword ON Logon(name,password) GO ...more >>

We installed MS SQL Server to our drive D drive E was the CDROM Drive. We wanted to move the CDROM drive to drive D and the hard drive to drive E. We change that around and corrected the registry entries - repointing everything to drive E instead of D. SQL Server however will not start it says...more >>

Hello, I receive a file containing some character fields along with a date. The date values in the file are formatted as "dd/mm/yy", that is 2-digit day, 2-digit month, and 2-digit year. The separator could be slash or a dash ("-"). The file is in a proprietary format, and bcp is not an opt...more >>

Hi, I keep getting this error message for a trans.log backup. Operating system error 112(error not found). The disk has about 6GB space free, and the backup should only take up about 550 MB, so I would think it is not space related but... The disk is ...more >>

Hello group- I am having a problem where joined tables are returning too many rows. Here is my scenario - I am trying to create a temporary table from parts of three tables - the important columns are: a.id a.tran_date b.id b.geo c.holiday_date c.geo My query is like this sel...more >>

It's blue in SQL Studio but I can't find it in SQL Books on-line. I wanted to use it as a field name but don't like using []. Is it reserved? ...more >>

Hi everyone. I need to be able to query a database in Oracle and then actually save the data in an MS SQL database, does anyone know what is the best way to do this? Would it be best to do everything internal (inside MS SQL) or external (with some script: javascript, vbscript, perl)? Thanks ...more >>

Is there any way to know aprox. how many cals a DB should have for an avg website. I don't really know how many concurrent users there will be. ...more >>

I am trying to create a view in MSSQL that has a column which is an auto increment (or unique id) field but it doesn't work the way I want it. Does anybody have an idea how to do this? The example below gives me only 0 in the id field. CREATE VIEW dbo.tree_x_categories AS SELECT @@ROWCOU...more >>

Hai all I am new to SLQ server. Can anyone tell me how to create a table that should look like a existing table fields.... thanx ...more >>

Hi, I was installing SQL Server on my machine and during installation my PC freezed. It happens frequently on my machine. So i tried after restarting to install it again and since then i always get the same error message: "An error occurred while creating one or more registry entries. Please ...more >>

Hi Is there a way to synchronise/replicate an access db with sql server 2000 db, short of writing the code oneself? Thanks Regards ...more >>

Hi We have an internal ms access database which we need to synchronise with our website with sql server 2005 backend which is hosted on a public host. My question is; is there a way to keep the two databases synchronised using the technologies built in sql server 2005 and/or access? We also ha...more >>

Are there any good resources (books, websites, etc) for programming SQL Server using Visual C++? I am currently using C# but I really want to learn how to do it using C++, but it appears to be much more difficult using C++. Thanks ...more >>

If you were doing paging of results on a web page and were interested in grabbing say records 10-20 of a result set. But also wanted to know the total # of records in the result set (so you could know the total # of pages in the set). Would it be better to query the DB table 2X. Once for Count...more >>

Anyone knows what the difference is between SQL Standard edition OLP and SQL Server in SBS 2003? I'm interested in purchasing SBS2003 because the price is much lower than if you buy OS2003 + SQL2003 separately. ...more >>

Hi, I have a .NET application that connects to a SQL 2000 database using trusted security. It eventually calls a stored procedure that receives 3 parameters - nothing special. If I simply change the connection string to use a valid Userid and Password it still connects to the DB w/o probl...more >>

Hi all, As the topic describes, I'd like to run a batch file using sql server. How do i do it? Thanks in advance ...more >>

I have the following table (which is an import from another system I can't mod):- CREATE TABLE [tbl_wsg_maternity_observations] ( [documentname] [varchar] (40), [clientguid] [decimal](16, 0) , [docguid] [decimal](16, 0) , [displayname] [varchar] (80), [valuetext] [varchar] (255) , [...more >>

I have uses DTS Import/Export wizard to export all my tables from one databse to another on the same server. How do I export all of my stored procedures and UDFs? Thanks, lq ...more >>

I have uses DTS Import/Export wizard to export all my tables from one databse to another on the same server. How do I export all of my stored procedures and UDFs? Thanks, lq ...more >>

Hi how to set the referential integrity between 2 tables using enterpris manager (microsoft SQL SERVER).. i tried and the tab doesn't allow m to choose. pls.help. thanks sre -- chavasreedha Message posted via http://www.exforsys.com for all your training needs ...more >>

Hello all, SQL Server 2000 documentation http://www.microsoft.com/technet/prodtechnol/sql/2000/reskit/part10/c3761.mspx states that if view is using "NOT NULL" columns of a base table, then insert/update performed on a view must provide dummy values for those columns, and code of the trigger...more >>

Hi all, I am having trouble getting linked Oracle 9 server in MS SQL Server 2005 Express to work properly. My machine is running Windows XP. The Microsoft and Oracle OLE DB Providers have problems dealing with Oracle's Numeric Data Type, so I decided to use Microsoft's OLE DB for ODBC Provi...more >>

Table DDL below: The tables I have contain Timesheet information. Each row in the tblTSCollected table contains an entry for an employee into the timesheet system, specifically by scanning the barcode on their badge. A whole bunch of business logic periodically attempts to "pair" these int...more >>

I'm new to sql server programing. Please help me to scedule a stored procedure to run every hour. Thnak you all. ...more >>

I have a column that has text delimited by a percent sign that I wish to turn into rows. Example: A column contains ROBERT%CAMARDA, I want to turn that into two rows, one row with ROBERT and antoher row with CAMARDA. I will have source rows that have zero, one, or many percent sign delimiters ...more >>

Hello, I am trying to create a view that shows the following Field1: Sum of Amounts from Table A Field2: Count of Amounts from Table A Field3: Sum of of Amounts from Table B Field4: Count of Amounts from Table B .. .. .. Field3: Sum of of Amounts from Table H Field4: Count of Amounts...more >>

Hi, I wrote the following in the SQL Server 2005 Express Management Studio Query Analyzer and hit execute. Even though Query Analyzer indicated success when I hit refresh on the stored procedure folder the procedure does not show up in the stored procedure list. When I entered 'exec Test' I g...more >>

I have a data set like so: UTC_TIME Timestamp NodeID Message Flag Line Station 11/19/2005 10:45:07 1132397107.91 1 3 5 1028 1034 11/3/2005 21:05:35 1131051935.20 2 3 5 1009 1043 11/25/2005 21:12:16 ...more >>

This is a tuffie, but I think I'll learn new techniques in SQL. I wish to put data from MS Active Directory and put it into a table. Specificly I want user information (first name, last name and so forth) and the groups that they belong into a SQL table. LDIFDE is a utility that can create a csv...more >>

Hi, I created a linked server for MS SQL Server 2005 Express to an Oracle database using the OLE DB Provider for ODBC. My ODBC Source uses the Microsoft ODBC for Oracle driver. I'm using the OLE DB Provider for ODBC instead of the Oracle OLE DB providers because those don't handle Oracle's Nu...more >>

Hello Config : SQL 2000 on WIN 2000 (IIS 5.0) In my ASP page for some queries i have this error : Microsoft OLE DB Provider for SQL Server error '80040e31' Timeout expired My asp page calls a stored procedure passing many parameters. I used the SQL profiler to get the exact store...more >>

I have a stored procedure that works fine on SQL Server 2000 or 2005, but when run on an machine running MSDE, I get the Operand type clash, int is incompatible with text data type error. The data type is actually text and text is the type of data being passed. Any parameters not being used ar...more >>

Is a single transaction log created for a database or, if you have a primary and a secondary file group in that database, are two transaction logs generated? Yep, a newbie. Thanks, Phil ...more >>

I've got a csv that I am trying to import into a SQL Server (2000) table through an adp (Access 2000). The form used gives the user the ability to browse for a file, then will import the file into a temp table for processing using this vba code: DoCmd.TransferText acImportDelim, , "tmpPaTimeC...more >>

I'm trying to create a online update form to a SQL table. I've never done this function before, and I'm not quite sure I have the coding correct. Below is the coding for the Update statement. final String udc = "UPDATE INTO " + "Comm_WebSubmission Set ProjectID = request.getParameter("Projec...more >>

What do you think of a query that generates a System.Data.SqlClient.SqlException when submitted via a application, but when run through QueryAnalyzer or EnterpriseManager doesn't generate a error? Here are 2 examples of the query: SELECT table1.*,table2.field1,table2.field2,table2.field3 FRO...more >>

Question: (SQL Server 2000) Can I arbitrarily delete a transaction log file in either bulk or full with a cron job and still be able to restore a backup? Or are the log and the .bak enmeshed to the extent that this not do-able? Details: I need to exclude a file group from a backup as it's stat...more >>

When a SQL statement is executed against a SQL Server database is there a server-side setting which dictates the size of the fetch buffer? We are having some blocking issues on a new server install which do not occur on the old server until a much larger volume of data is selected. Any help ap...more >>