Programming SQL

Access to list of temp tables from a SP?
Hello All I wotk with SQL2005. How can I find that a specified temporary table exist or not without using tempdb database. I want to check if from a function or SP? thanks in advance ... 28 Jun 2008 03:31

Constants and variables
Hello, In a query, we have a WHERE clause containing two tests on unique identifiers like this : WHERE GUID1 = @Guid1 AND GUID2 <> @Guid2 AND something else In our particular query, it needs 7 seconds to complete. Now, if I replace one of the two variables by its constant value, it completes in 2 seconds... 28 Jun 2008 03:31

Table Data Fragmentation vs Table’s Index Fragmentation
Hi, I am trying to understand why there is so much emphasize on Index fragmentations whereas we can't find any effort to eliminate the actual table's data pages fragmentation. When a table's data pages are fragmented across a database file, can we make all data a page continues? Thank you, Max ... 28 Jun 2008 01:29

Query Total Order Count to Date by Month
I need to write a query that returns the total orders to date by month. Based on the sample Northwind database, I have created a query that shows the number of orders placed each month: SELECT MoYr = DATEADD(m, DATEDIFF(m, 0, OrderDate), 0), OrderCnt = COUNT(*) FROM Orders GROUP BY DATEADD(m, DATEDIFF(m, 0, ... 27 Jun 2008 23:26

SYNONYM for database name?
Hi, I have two databases that work tightly together. That means the stored procedures include lots of cross database queries. The problem is that when the name of either of the two databases might change and all cross database queries in stored procedures won't work anymore. I am trying to find a way t... 3 Jul 2008 17:40

How to upgrade from Sql Server 2000 Personal Edition to Enterprise
If you're talking about the technical process of migrating the database from one edition of 2000 to 2000 Enterprise, it is simply a matter of backing up from 2000 and then restoring on 2000 Enterprise, or detaching / retaching. "satyanarayan sahoo" wrote: Where i can get these upgrades ? ... 27 Jun 2008 17:18

Application Role
Hello SQL Gurus, Trying to use application role to control user access to the data. We need to prevent them from connecting outside the application. SQL Server 2000 sp4. 1. create an application role 2. granted execute permission on a stored procedure to the new approle 3. when the application invokes the ... 29 Jun 2008 07:04

Problems with Bulk Insert and Format File
Im having an issue using bulk insert from a fixed width file using a format file. [SQL2k5]. It seems that with each row the starting position of my column is being moved and spaces are being added to the data so by the time row 5 or so is loaded column 2 now contains part of the data that is supposed to be in c... 27 Jun 2008 19:21

import export unsuccessful delete
hey all, i'm in sql2005 and i'm using import wizard where i specify to delete existing records and enable identity insert. for some reason, unknown to me, it's running as though the delete didn't occur and it just adds it anyway. in addition, the process errors when an attempt to add a duplicate key occurs. c... 27 Jun 2008 16:16

Incorrect syntax near '1' error from sql server 2005
On Jun 27, 11:28 am, rajesh <techsat...(a)gmail.com> wrote: Hi When i am trying to run this SP i get Incorrect syntax near '1' error from sql server 2005. Here are the SP Values i pass. exec aspnet_Membership_CreateUser 'b3302ad3-6814-4ee8-b5ec-bce1210e6730', 'testuser555', 'Rajesh123', ... 27 Jun 2008 12:09