Microsoft SQL Server Forum

how to show all tables in current database ?

Hi everybody, I was looking for an equivalent ORACLE INSTR Function in MSSQL but I don´t found it and I don´t know if it exist so I must to write it and this is the code. Maybe it will be helful to you: /*************************************************************************** Description: Looks for a string inside another string and...

I want to retrieve the list of all logins in the sql server. can anyone help me in that?

Hello, I am trying to do something out of the ordinary. I have searched the forums to no avail. I have two SQL tables containing inventory data of the same items but the descriptions are not exactly the same (one table is from an insurance company, the other from an independent contractor). I need to reconcile the item numbers from one table...

sql server 2000 8.00.194 Microsoft Windows 2000 Service Pack 2 I looked into my sqlserver agent log and found the following ODBC Error 0 Timeout expired logon to server local '( failed)' (Job manager) I have no idea what that means but it did keep out users for a minute or more. The threads found on this forum almost all point to...

Hello all. Is there a simpler way to write something like this: select column_a from table where column_b = ( select max( column_b ) from table ) ie. find the row where column_b is at it's maximum and return another column's value?

Hey guys, I'm pretty new to SQL configuration, and I need to give EXECUTE persmissions for one of the SQL user roles. I am running SQL 2005 Management Studio Express - free version. I found the list of my stored procedures, but I can not locate any permissions screen. Can someone help point me in the right direction? Thanks!

Hi everybody, I need some help in SQL Server. I am looking for a command that will "Drop all user table" in a user database. Can anyone help me? Thank you very much Sabrina

Greetings, Are there any tools freely available to modify or edit a .mdf database file? As far as seeing the actual tables? Regards, cd

Hi I'm working on an ASP project where the clients want to be able to effectively perform SELECT queries joining tables from two different databases (located on the same SQL-Server). Does this involve creating virtual tables that link to another database, or am I completely on the wrong track? Any hints as to where I might find more...

Hello, I need to write a query to find out a set of missing number in a given sequence. Eg : a Column in some table has the following data

Background: I am currently working on a mission critical web based application that is accessed 24 hours a day by users from just about every time zone. We use MS SQL Server as our database and we have lots of problems with time-outs. We used to have lots of problems with locks until my management decided that we would use the WITH (NOLOCK)...

Hi All, For hardware upgratdation we have to move our database server(MSSQL 2000) from a P3(Window 2003) machine to a p4(Windows 2003) machine. We have replicated the data from P3 machine to P4 machine. the replication was success full. After this we have changed the name of the p4 machine to tha of p3 machine.

Hi this is my first visit to the MSSQL forum with a question. Let me explain the scenario, I have a table say clients table with the structure like id,foo,etc.. and lots of records on it. But the issue is this id column is not an IDENTITY column. But the values for the Id column don’t repeat since it has handled from the application...

I have an existing table: CREATE TABLE TestQuestions ( qId int NOT NULL IDENTITY(1,1) CONSTRAINT PK_TestQuestions PRIMARY KEY NONCLUSTERED, testId int NOT NULL REFERENCES Tests(testId) ON DELETE CASCADE,

I'm doing a bcp out of a table to a file. Some of the fields in a record may have an empty string. When I bcp out to the file and examine it, the fields that have an empty string in the database now show up in the file as having one blank character. Why is bcp doing this? I don't want the blank character in my output. Thanks,

Hi, I have a query that is sorting people into their respective areas of the country and need to assign each postcode the correct label (Eg: 'North', 'Wales', etc.). I am trying to do this in a CASE statement at the moment but it does not like the IN() part, returning all the values with the 'N/A' label. Everything parses fine and the query...

Hi, is there a rule of thumb what is better/faster/more performant in SQL Server 2005? a) SELECT * FROM A INNER JOIN B ON B.ID = A.ID AND B.Cond1 = 1 AND B.Cond2 = 2 b) SELECT * FROM A INNER JOIN B ON B.ID = A.ID WHERE B.Cond1 = 1 AND B.Cond2 = 2

Hi, I have an access 2003 database which connect to sql server via a DSN that goes through a VPN. The database works fine and everyone can coonect from their normal computers but for anyone working on their Laptops (IBM Think Pad T42's) they cannnot connect to the datasource. The DSN fails upon connection attempt with : Connection Failed:...

When I want to delete a data from a table that this tabl has a trigger and this trigger reached another tables to delete the data in cursor I have this messeage: DELETE failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'. My trigger : CREATE TRIGGER ON . FOR DELETE

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 NTFS. Any ideas?

Hello I accidentaly ran a DELETE command against a table with a wrong WHERE clause. My database had no backup, but the recovery model was Full. I am using SQL Server 2005. Is there a way, or any utility software that could help me recover the lost data? The .ldf file is twice as big than the .mdf file, so I think that my

I need just the names of tables, views and sprocs within a SQL Server database. What's the easiest way to do this?

Hi There, I am a newbie on SQL qieries and I am trying to run a query on a date/time filed to get yesterdays data. Here is my test query ran from SQL analyzer: select * from mvs_store_all_data_time_change where mvs_creation_date = {fn NOW() } The error I am getting is:

Hi, I have some tables where I import data in, lots of field have gotten a NULL value which the application can not handle. Now can I replace each NULL value with '' in a columns with: update <tableset = '' where IS NULL But because there are lots of columns this is pretty much work, also there are multiple tables.