Can someone give me the syntax to write a query that will return the greatest number of characters in a specified column. Basically, I am in the process of converting a table's nChar fields a...
How can I export a list of mssql logins which includes the database permisions? When I go to "security" and "export list" all I get is the overview. I need to remove a bunch of permissions a...
Hi Everyone,
I'm working on a Stored Procedure which I will later use to create a report in Crystal Reports. The Report is going to be a Time Summary Report which will list timekeepers, ho...
I have a table in DATEBASE1 called Orders. Its PK column is called OrderID and the Identity Property is set to True, the Identity Seed and Identity Increment are both set to 1.
In DATABASE2...
Hi,
I am in no way a DBA but have been assigned the task of developping some basic maintenance plans to use in combination with our application. I have created said maintenance plans in MS ...
Please help me.
I want to transfer some data twice a month from table1 to table2 on same server
with following conditions and i want to rebuilt index on table table1 after each time i tran...
Hi All,
A few questions about Log File usage in MSSQL Server 2000.
Q1. Does providing a table with Clustered Index causes Log File Space to grow ?
Q2. How can I reclaim OS Space from lo...
Before installing SQL 2005 I take file backups (.bak) of system databases such as master, msdb etc.
We do not have sql 2000 now and suppose that we dont want it either.
In order to get bac...
Hi experts, I need some help analyzing/solving some replication errors between my distribution server and my prd server. Don't know much about replication. I looked at the replication on the p...
Recently my production server name has changed and wants to modify all the connections strings that I am using in my DTS packages.
Can any one tell me how can I change the connection string...
Hello! I need to connect to two MS SQL servers from an ASP page and do a INNNER JOIN between them.
I would like to do all work in the ASP page not on the actual server.
If I do the question...
I am working on testing a new SQL 2005 server, migrating from SQL 2000. A couple months ago I successfully copied all databases and logins (with SIDs and passwords) from the 2000 server to th...
I know exactly what log shipping is but what is the difference between that and mirroring and replication.
What are the advantages of each - I have a project to sync a database from our sit...
Experts, I have an .RDL file and i want to display another column in the resulting report. I copied the existing column and changed the name and value associated to the new one that i wanted t...
Can anyone see why this Condition won't work?
http://www.files2net.com/files/161362108/conditional_split_transformation_editor.JPG
This is the error I'm getting:
TITLE: Microsoft Vi...
Hi
can anyone give the command to update table statistics please?
and if possible a brief description of what it does?
Thanks
Hi Guys,
I would like to know if i get MSSQL to return the current time in a specific timezone.
I would like a function like this :
castFromServer ( getDate , "the_timezone_I_am_after...
I have a number of SQl 2000 servers on my network, 2 are remote web accessed servers.
When i use linked servers, from my pc (xp pro running sql 2000) i link either using current security co...
I have 3 tables
members
groups
group_map
Members is a simple table that holds user information. Their ID is auto incremented.
Groups is a table that holds groups that members could be ...
While using an SQL statement to update a database, a NULL value will not update and causes an Arithmetic Overflow error converting numeric to datatype numeric. How do I stop this from occurri...
I have set up a linked servers on my development and test 2000 sql servers successfully but I cannot seem to set uo and connect successfully on my production 2000 sql server.
On production...
I have a text file that I import into a single column of a staging table. The data has 75 recurring groups of data. Currently, I have a WHILE loop that makes 75 passes through the data, each t...
Hello, I have been trying to understand how to properly format a unique constraint for multiple columns in a table - essentially I am trying to ensure that the combination of these three field...
I am using SQL server 2000.
I have 2 servers that I have linked.
I can write a query and SELECT * from the linked server w/o problem
When I try
SELECT
Field1,
Field2,
etc
INT...
I am wondering if someone can point me in the right direction to creating a Table of Contents using SSRS. The end result is a printable report that can be handed in.
