how can i grant a user a temporary SA permission for a spesific action (like alter a column in a table)? thanks ...more >>

I have question about RAISERROR command. Look at the example above. first select shows one record in table, that means that transaction was committed. second select shows that transaction was not committed. My intention is raising exception similar to PK constraint violation. As you see from...more >>

I am trying to reference files in my SQL db which are stored on my database. I do not want to store the files in the actual database. I have a web interface where the user searches for the file finds the referenced file then tries to download it. But for some reason when they try to download t...more >>

I am new to SQL 2000 Administration. My SQL Server has started indicating a lot more disk activity than it has done in the past. There are no jobs being run and it is degrading the performance of the system. How can I track the problem to the source? Thanks in advance....more >>

I parse a querystring from a .net website into a stored proc; ALTER PROCEDURE Postlists_CreateList ( @Groups varchar(255) = NULL ... ) AS INSERT INTO Postlists_Recipients (PostlistID,UserID) SELECT @PostlistID, UserID FROM UsersInGroups WHERE UsersInGroups.GroupID IN (@G...more >>

I am connecting to a remote SQL Server database from Visual Studio .NET 2005. I have an sql script located on my machine containing the sql code I want to use to create several tables, and want to execute it. How can I do this from Visual Studio .NET 2005? I do not like designing the database ...more >>

dim gConn as new adodb.connection gConn.open "...." strSQL = "sp_rename 'mytable', 'mytable1','OBJECT'" gConn.Execute strSQL, , adCmdStoredProc Why last SQL command cannot be executed? ...more >>

This one is going to be so easy once I get an answer. When I do a select on a table with a DateTime field I get an answer of "2006-09-27 16:23:24.000". When I SELECT that into a variable with a DateTime format I get "Sep 27 2006 4:23PM'. What I want is to get select format in a variable. ...more >>

Hi, I am trying to write a t-sql with nested while loop and table variable instead of cursors. Can some one pls help me if am doing correct with the below code. eg declare @myTable table (rowId int identity(1,1), p1 int, p2 int, p3 int) declare @nmyTable table (rowI...more >>

I am having an issue with a query that is trying to compare a string date to today's date I have a table like this PC Name Date (year-month-day) (Varchar) PC1 2006-02-20 PC2 2008-11-11 PC3 2007-08-29 Etc. Etc. ...more >>

I can't seem to find confirmation of this anywhere... When I do a backup using the maintenance plan in enterprise manager, does it include EVERYTHING? ie... stored procedures, views, users, Or does it only backup the data, requiring a reinstallation of everything else? THanks,...more >>

I wrote a store procedure like this: declare @dbname nvarchar(50) declare db_cursor cursor for select name as database_name from master.dbo.sysdatabases where has_dbaccess(name) = 1 and (name like '[0-9]%') open db_cursor FETCH NEXT FROM db_cursor INTO @dbname WHILE @@FETCH_STAT...more >>

Hello. I don't understand the SQL Databases. I was once using MSDE of SQL2000(Server name = DHJC2R91). Since playing with VWD, i downloaded and installed SQL Server 2005 Express Edition(It gave me a server name of DHJC2R91\SQLEXPRESS). After that when i use the systray icon with the li...more >>

Hi, I installed SQL 2005 onto my D: drive but somehow the data is being stored on my C: drive. (I only noticed this when my c: drive filled up!). In Server Properties, there is a Default location for datafiles box. If I just enter the desired location in there (it's currently blank) will the...more >>

Hi- We need to find out when records are added or changed in a vendor's database for a customer. The customer has said that we can't add triggers nor make other changes to their database. I've been familiar in the past with SQL databases (Oracle, Informix), but haven't been using them curre...more >>

What is the best way to manage Log file growth?? We have a document management program and the MDF file is about 3.5 gig, but the LDF file suddenly ballooned up to 34 gig. The data is backed up nightly and the logs are backed up hourly. I thought that would allow the log file to "flush ou...more >>

Hello, I have a table where a value is saved as an integer (value 0, 1, 2). Now the customer wants to have this presented as "Low", "Normal", "High" Is there some SQL magic that can create a recordset where the integers is replaced with the text? // Anders -- English is not my first,...more >>

I am new to this so hopefully you'll bare with me if this is a stupid question. I receive data in a dbf format from the state office on a yearly basis. I have figured out how to use SSIS to pull these into the SQL system as different tables (e. Birth2002, Birth2003, Birth2004) within a sing...more >>

Hello. I'm restoring databases from their .BAK files and everything went smoothly until the last 2. this is the error message I am recieving in Enterprise Manager when I attempt to restore from device : ----------------------------------------------------------- Device activation error....more >>

A third party app supplies a table in a SQL database. Unfortunately they have chosen to end all their field names with # or @. If I create a view, and include a @ field, the diagram pane will not be available next time I open that view. Is there a way around this? Thanks Vayse ...more >>

Does anyone here read the magazine "SQL Server Professional" by Pinnacle? I got a sample copy and it seems really informative and well written. It's expensive though, but if the whole subscription is as good as the trial copy, I think it would be worth it. What do developers think? Is it worth...more >>

Hello, I have SQL Server Desktop version 7 running on my laptop. I am using as a data source for Cognos DecisionStream. The issue I am having is that my database has grown quite large. Everytime I try to do anything, my database is EXTREMELY slow. What can I do to increase the speed/efficien...more >>

Running SQLServer2000 SP3. I have a database (DB1). I need to make a copy of that database (DB1_Test). The new database (db1_Test) should have all of the structures, permissions, etc. I don't want any of the data. Can someone help me? -- Tom...more >>

I'm running SQLServer 2000 Standard. I have a database that is set for Recovery Mode = Simple. The dboption "trunc. log on ckpt." is set to TRUE. I have also issued the truncate log command "BACKUP LOG DB_Name WITH TRUNCATE_ONLY". I have penty of available disk space. I still get the fo...more >>

Hello, If I have this table: IdNo int Version int data ... IdNo and Version is the primary key. How would I write an SQL query to get the latest version of a all IdNo? // Anders -- English is not my first, or second, language so anything strange, or insulting, is due to the tra...more >>

I've just split my db and am using Access as my front end. Are there any advantages / additional functionalities of having SQL Server as my back end that I can take advantage of? ...more >>

SMS Query complains about the backslash in the following statement. ALTER SCHEMA dbo TRANSFER OWRD\julainih.AuthorList The old trick of doubling the backslash ALTER SCHEMA dbo TRANSFER OWRD\\julainih.AuthorList doesn't work either. What do I need to change to let this statemen...more >>

Hi, I've been trying to find desupport dates for SQL server 2000, but having difficulty finding anything. Can someone provide this information to me. Also, information about upgrading to 2005 would be helpful too. Thanks, Mike...more >>

I have the following "Where" clause WHERE (dbo.UserLogin.Enable = 1) AND (dbo.Users.Archivedcont = 0) and convert(char(8), loginstartime, 108) < convert(char(8), getdate(), 108) and convert(char(8), getdate(), 108) < convert(char(8), loginendtime, 108) But I only want the second line of the...more >>

I have the following query: Select convert(char(8), loginstartime, 108) as startime, convert(char(8), loginendtime, 108) as endtime from userlogin It returns two values: startime = 08:00:00 endtime = 18:30:00 Right now it is 10:40 am If I add a where clause I get no results when in...more >>

hi, I need to synchronise local and remote database but only the stored procedures... Any ideas on how to collect all local ones and then create these on remote db? ...more >>

So, I have a View built where the criteria on a date field is as follows: > { fn NOW() } ..... but what its showing, is everthing from TOMORROW forward... I still need for it to display TODAY's information as well. What do I set in criteria to show this? > "yesterday" somehow??? ...more >>

I thought that when you installed SQL Server 2000 the installation automatically recognized an instance of MSDE and offered to upgrade you. Well, after having installed SQL Server 2000 it looks like my database still thinks that it's MSDE. At least I have both SQL Server 2000 and MSDE runnin...more >>

Hi, I am using ASP/VB and MS SQL 2000 DB. I have a date field that just holds a 'time', say 8:00 am Then I have an ASP page where the user enters the time to compare, they will search for results that have 'time' field between say 7 am 10, in this case the record with 8:00 am should be di...more >>

Is it fair to assume that the maxium number of Index on any given table in SQL Server 2005 is 249 and 1 index can be clusted for a maxium of 250? Is this count also the maxium number of relationships that can stem from that table. I am pretty sure it is, but I would like other experts to comme...more >>

how can i insert an access recordset to an sqlserver table? thanks ...more >>

how can I update only top 20 rows in a table? The table consists of PostlistID int, UserID int, Send_Begin datetime, Send_End datetime and what I'm doing is to sequentally -grab next 20 rows of recipients and set Send_Begin to GetDate() -send these users email -update Send_End to ...more >>

Hi, we need to purchase SQL Server 2005 for a new hr system that is being installed. We are thinking of getting the Microsoft SQL Server Standard Edition 2005. It says that it comes with 1 server license and 5 user cal licenses. Forgive me for this really dumb question but what does the 5 u...more >>

Hi, I am fairly new to T-SQL although I would not classify myself as a complete beginner. Last week I came across a strange business requirement for an application, and I am still trying to figure out how to address it in T-SQL. I need to pull a list of each customer's last order for a s...more >>

When I try to install SQL Server 2005 I get a message that says: SQL Server 2005 Setup has detected incompatible components from beta versions of Visual Studio, .NET Framework, or SQL Server 2005. Use Add and Remove Programs to remove these components. I haven't installed any beta softwar...more >>

Hi, I have a stored proc that returns an entryid. When i tried to execute the proc and assign to a variable in the sql analyzer, i am not getting the correct output in the variable For eg: In the make_user_signup stored proc, ...... ....... Select @entry_id as EntryID GO When i d...more >>

I have a database where I need to change all period to post information back 1 year. There are approx 400 tables and most of them have a perpost field where the Period to post information is stored. I need to take this information back 12 months for all perpost fields. eg Perpost in APDOC ...more >>

I got this error: Msg 2739, Level 16, State 1, Line 1 The text, ntext, and image data types are invalid for local variables. I wanted to create a stored procedure I could call from my web application to insert data into a table. If I can't use ntext as a variable for a stored procedure, the...more >>

I'm trying to create a new user for my MSSQL database through the Enterprise Manager. In the SQL Server Login Properties dialog box, I type in for Name: "Ken", I choose SQL Server Authentication (Windows Authentication won't work) and type in my password. For the default Database, I choose "KenJ...more >>

I posted this a while back but without luck. I am just now getting back to what I started last month and still have this question. Basically, how do I add data to a field that is a foreign key? Thanks, bob "Bob Weiner" <bob@engr.uconn.edu> wrote in message news:EFC65156-1F16-47C8-B25C-A...more >>

I have 2 tables. Simplified down to relevant fields. Table 1 id referenceName currentStatus Table 2 id table1Id transactionStatus There is a many to 1 relationship between table 2 and table 1. Table 1 holds 1 reference record and Table 2 can have multiple records, each having ...more >>

I recently purchased Office 2003 professional that came with SQL, which I understand is needd if I want to use MS Outlook contact management. When attempting to install on my Dell PC, that came with XP Media Edition 2004 installed, the installation hangs up with two seconds to completion. ...more >>

I am posting this in this group only because I don't see any other group that is specific to the issue (i.e. Management or Backup). Anywell, I have had three seperate maintenace plans set up on our SQL 2000 Standard box since we set it up in 2001. I am completely perplexed as to why every ...more >>

I am trying to make an SQL UNION Statement, but I get this error: Server: Msg 8163, Level 16, State 4, Line 1 The text, ntext, or image data type cannot be selected as DISTINCT. This is my sql: SELECT activities.activityid, activities.Actname, activities.actdesc,activities.schdemailon, a...more >>

Hi there! Our hotel accountant's computer used to use Great Plains for our hotel accounting. We also have SQLserver installed, which I guess had something to do with it... although I'm not sure We are no longer using Great Plains... is it safe to remove SQL server, or is it so intertwine...more >>