Microsoft SQL Server Forum

hi all this is my first post to this group, so pls bear with me while i try to make some sense. i am trying to create a sproc which uses dynamic sql to target a particuar table eg. '.' and perform some actions. i am using @tableID as a passes parameter for the sproc.

i wanted to restore user DB from one sql server to another sql server , one database is having so many table and have user called digi he is created so many SP and some tables., when i restore the db it restored without any problem., after restoring application is not working how to ensure that restored DB is having same security as the...

I'm trying to use a servlet to process a form, then send that data to an SQL server stored procedure. I'm using the WebLogic 8 App. server. I am able to retrieve database information, so I know my application server can talk to the database. I've determined the failure occurs when the the following statement is executed: cstmt.execute(); (due...

I need to run a query which will pull data from two tables and append it as one when it displays the result. The data are in two tables. But the result set will be identical in terms of number of columns. I want to display it one set below the other. This is for pay history. From 2003 we have a new payroll system. Till 2002 we used to have...

Hello: I'm new in the SQL server world. But I need to copy one SQL database on machineA to machineB. By looking at the tool bar, I think export will do the job for me, is anybody can provide the detail info? DO I need to create an empty database on MachineB first, any documentation repository I can read and learn? Thank you so much!...

I cannot seem to find a group where this question would fit so I am posting it here. I have what I believe is a unique situation. I am using SQL Server Analysis Server to build a cube of "snapshot" month-end type of data. This data is from an instance of Microsoft Navision and I have successfully used SQL-DMO and DTSPackage Library objects...

If connection properties and global variables are set from an INI file, how can a DTS package be made truly portable? If the INI file pathname is hard-coded in the package, it must be edited when you copy the package to a new environment; otherwise your packages in multiple environments will all reference the same INI file. If there are...

Hi Everyone, I've got a question and I think the answer can be a single SQL statement. In fact, I think I might've done this before, but I can't find the SQL. I've got a table with names and different bugs and status ids. I'd like to get a query that totals the various statuses. For instance, the table is Name bugid status Jeff 12 open

Goodmorning, I can't connect to a DbServer in my Lan ,because the server gives me an error ,"not trusted connection" when i try to connect with an account predefined. Could you give me some hints? Thanks Roberto

If I copy a Database backup to a CD; can I resotre to a different server? Thank you

Hi. I am quite new into stored procedures written in t-sql. (MSSQL server) I have three different tables in my DB. Two of the tables (with different data) are updated regularly and need to be joined into a third table that works as the basis for an application in ASP. The two former tables each contain a field with a persons identity...

I have a backup of database from work. In home I don't have this database on my server. How to resore it in home? It is possible? (In work I don't have permission do backup database) And finally what will be with permissions? If in work I have permision to read only. If I restore this database at home, will i have the same permission or I...

We're building a company wide network monitoring system in Java, and need some advice on the database design and tuning. The application will need to concurrently INSERT, DELETE, and SELECT from our EVENT table as efficiently as possible. We plan to implement an INSERT thread, a DELETE thread, and a SELECT thread within our Java program. ...

HI all, This has puzzled me all morning. I have a int field which reads 19691124 (UK dates) this is actually a date 24 November 1969 I need to add 28 years to this making it 19971124 but I’m stumped! Any ideas anyone? Cheers Sean

Hello, I have this peculiar problem concerning MS SQL Server. My company works with an mailing application (ASP) which uses SQL Server as it's repository. What I want to do is send data directly from my own application to this SQL Server in order to feed the mailing application. To test if this was possible I linked the tables from SQL...

In propery page of view there is option "Bind to Schema" ,What does it mean and how does it work? Second:What is schema exactly? Thanks

Hello I have a case where Partners are some kind of Super-Users and are stored in a SQL Server database. Best is IMO to put both in the same table: table Customers: CustomerID PartnerID

Is it a good thing to do? what are the cons? Are there any risks? (this is an ISP database running 24 hrs) I have sql 6.5 on Win NT with 256 MB Ram (64 MB reserved for SQL Server). tempdb size is 10 MB. Currently i'm experiencing slow response for large queries and sometimes users have problems logging on the internet (authentication stops). ...

Hi, I am using a SQLServer 7 SP4 version. I have scheduled one job with the SQLServer agent which backup the log of the databases every day. The command is : "backup log base to with noinit" At the end of the command, the logfile shrink from 20Mo to 1Mo. I don't understand because I though that only 'backup log with

From reading other posts, and modifying supplied scripts we have a CS server. Our new software package seems to need a CI database. The software developer says SQL is not case sensitive and our SQL must be broke. So ... How do I create a new database with enterprise manager with CI? We are running MS Windows 2000 Server for...

When I run: select * from testtable I get this error message: Invalid object name 'testtable'. However, if I run: select * from testuser.testtable

What methods are people using out there to keep their stored procedures under CM control? We are using CVS for our CM system. Looking for an easy way to get stored procedures scripted out as text so we can check in/check out of a CM system. Thanks! -- Mike Brown

Hi, I had this problem in version 7 and dont remneber How I solved it!! I have installed a local SQL Server (2000 aka version 8) on my Worksation (W2K), I have picked NT authuntication. Everything was fine untill I changed my password. Now SQL server can not start because it fails to login. The old password is embedded somwhere and I cant...

A format file provides a way to bulk copy data selectively from a data file to an instance of SQL Server. This allows the transfer of data to a table when there is a mismatch between fields in the data file and columns in the table. I take it this assumes the number of fields in the data file will always be constant. What if it is not? My...

Hi; I need some help in writing a query and the following is what I am trying to do. SELECT VALUE_ID FROM CC000.VVALIDITYVALUE WHERE (CATEGORY_ID = 2) The above Query will give will every Value_ID where the Category_ID =2. Then